Compare Databases

[MikeAngelastro]

I did a search within the forum for this but didn't find a posting that dealt with this issue.

I have a few back-end databases that, all though the data will be different among them, the structures should be the same. Because I am constantly customizing the program, I occasionally have to add fields and/or tables to the back-ends. So there is a risk that a change I make to one of the backends does not get copied to the others.

Does anyone know where I can find sample code that would help me compare the structures of two or more databases? I would also like to be able to add tables and fields if necessary with the code.

 

[Pat Hartman]

Try FMS for a db compare utility. Try DatabaseCreations for an update utility.

 

[MikeAngelastro]

Thanks Pat. I'll check them out.