Synchronizing Access Database Schema

[Rene]

I am looking for a utility that will allow me to compare two Access database
schemas and tell me what the differences are. As a bonus, I would also like
the tool to generate an SQL script or C#/VB .Net code to synchronize the
schemas but this is not really necessary.

Thanks for your help.

 

[John Vinson]

I am looking for a utility that will allow me to compare two Access database
schemas and tell me what the differences are. As a bonus, I would also like
the tool to generate an SQL script or C#/VB .Net code to synchronize the
schemas but this is not really necessary.

Thanks for your help.

Total Access Detective, from FMS Inc. will do the comparison anyway:
http://www.fmsinc.com


Note that a database typically contains a lot more than a schema or
the tables.

John W. Vinson[MVP]

 

[sualeh.fatehi]

If you are willing to use Java, there is a free open-source tool called
SchemaCrawler on SourceForge that can compare schemas and even data.

Download SchemaCrawler from:
http://sourceforge.net/project/showfiles.php?group_id=148383