2 databases, same fields

[YuChieh]

I have two databases with many same fields. I have changed a lot of fields definition (such as calculations) in one database (which contains about 1200 fields). Now I need to do the same with the other database (which contain 800 fields) so they can match.

Is there an easy way to change(or import) the calculation fields in the second database? Or I need to compare and copy/paste them manually?

I am using FM Pro 6 (or developer) on Win XP.

Thanks.

[Lee Smith]

You can [color:"blue"]not import the Define Fields data. Your only choice is to Copy and Paste the Calculations.

HTH

Lee

[YuChieh]

nooooooo!! oh well.

Is there a way to write a script to retrieve the re-used fields from the first database?

thanks

[Ender]

I'd venture that your structure is not normalized if you have 1200 and 800 fields. This sounds like way too many for one file.

[YuChieh]

Yes, I know. But this whole thing was created by someone else. I just update the formula stuff.

From my database and programming background with SQL server, you are right, it's so not normalized.

[Oldfogey]

It might be easier to duplicate the database you've fixed and then import the data from the other db into the duplicate and then delete all the fields you do not need.

(The mind boggles at 1200 fields!)