Updating a live database when the users have it, but retaining the data inside
I have two questions based roughly around the tagline above.
1) I'm working on a solution which is continually being developed. The solution goes to version 1.0 and gets given to a user. They fill it with data for a year, shall we say. During that time, I improve and change the solution until it reaches version 2.0.
How do I get version 2.0 to the user and update the layouts, features etc, but ensure all the data they've entered remains intact? Do you need to export from their version 1.0 and re-import to version 2.0?
2) On a similar topic (forgive this not being on the server forum), if I install FM server and run the same scenario, how would that work?
In a server environment, how do I roll out an improved version of a pre-existing FM solution without destroying existing FM data?
Hope this makes sense