Compare 2 Database's Tables

[DBG]

Hi, is there a quick routine or app to compare the tables between 2 databases.

In this instance, I have 6 sub versions of a database and want to determine
what minor table changes might have been made to field size etc.

If not, I've already written a routine which dumps the info to a text file
from one database, and will write a perl routine to do the matching or use a
text diff tool to find the differences.

Thanks!

-David

 

[dbahooker]

most tools like this-- are designed for use with SQL Server. you see--
most people don't take MDB seriously

I would reccomend moving all of your data to SQL Server; using Access
Data Projects to keep your existing forms and reports.

and the buying a commercial product for comparing SQL tables.

As it is-- i just woudln't waste my time with MDB.

 

[TC]

I wrote a small tool for that purpose. But all it did was to dump the
relevant details to text files, then use a file compare utility - much
like what you are thinking of.

Remember there is a documentor tool in the Tools menu somewhere (I
don't have Access here to check). But the output from that is fairly
verbose, it might not be good for comparison purposes.

Maybe http:www.fmsinc.com have something?

HTH,
TC [MVP Access]

 

[Naresh Nichani]

Hi:

Also take a look at
http://www.microsoft.com/india/msdn/articles/DatabaseUtility.aspx

Regards,

Naresh Nichani
Microsoft Access MVP