Separating Data

[Leather Knight]

I have a desktop solution that has 14 different databases in it. I need to be able to make updates to the solution/databases without data loss and not good with mysql or other database operations to store the data. I need help in making this happen and need a quote for doing it. Even if it is a simple script that will export data and import it back into the new solution would be great. Or creating a separated solution. Please let me know if you can do this.

[David McQueen]

I have a desktop solution that has 14 different databases in it. I need to be able to make updates to the solution/databases without data loss and not good with mysql or other database operations to store the data. I need help in making this happen and need a quote for doing it. Even if it is a simple script that will export data and import it back into the new solution would be great. Or creating a separated solution. Please let me know if you can do this.

Hi Kevin,

More questions than answers here:

1. By Desktop Solution, do you mean a FileMaker Pro file running using a standard version of filemaker Pro or do you mean a runtime solution bound to its particular crippled version of Filemaker?

2. You have 14 different databases. (a) What version of fileMaker and ( do you mean 14 different tables within a file or 14 different files?

3. Have you already planned for version control within the program?

4. What are the security considerations for the data being migrated? As soon as you put the data outside the native FileMaker permissions envelop,you are subjecting this data to outside scrutiny with no real control.

In the best of all possible worlds, this is one file running on a standard version of FileMaker Pro. Then you set up an external migration file that knows all future versions and moves the data from the old to the new, never storing any data itself and never exposing the data outside the existing security envelop and doing it seamlessly to the user. It is also the most expensive to do.

Please post more or contact me directly if you like.