Jump to content
Sign in to follow this  
SoCalMacDude

Migrating FM6 relational DB's to FM7 Tables

Recommended Posts

Hope I'm in the right forum (if not please move me!).

Is it possible to take several FM6 databases which are relational, and turn them into 1 FM7 database as multiple tables?

If so, how??? :-)

Share this post


Link to post
Share on other sites

Yes!

How: either buy FM Robot, or re-build everything into the main file. The ability to Copy & Paste tables and files in FMP Advanced makes this much, much easier.

My experience (and that of many others) is that any FM6 system of reasonable complexity is better off being re-written in the latest version (especially so with FMP 9.0).

By all means do a conversion, but use this as a prototype for the new system. If necessary put the conversion into production while the re-write is being done.

You MUST read the migration white paper at the FMI web site.

Share this post


Link to post
Share on other sites

Thanks.

I see there is an import button in the Define Tables dialog box, and it imports the fields, but no layouts or value lists. I can paste in the layouts, re-create the value lists, but then, after setting up the relationships, I must re-direct the scripts to perform correctly.

Thankfully, when I paste in the layout, the fields appear to hook up correctly and automatically.

Any other details anyone would like to add? Any gotcha's I haven't run into yet? No doubt there will be.

Share this post


Link to post
Share on other sites

There is a specific order that's useful to follow to avoid having to fix references to elements:

1. Import or retype the fields.

2. Add any necessary relationships, making sure the TOs have the same names.

3. Define blank layouts with the same names as those from the original file.

4. Copy and Paste any necessary value lists.

5. Import any necessary scripts.

6. Copy and paste the layouts.

7. Go back and fix any calc definitions that were commented out.

8. Test everything.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.