Toad World® Forums

Schema Compare using Data Point

I am using Toad Data Point 3.7.0.973 with MS Access files. Is there a way to perform a schema compare between two connections for differences in the structure of the tables? I see that feature discussed in some of the other Toad tools (e.g. Toad for Oracle & SQL Server) but it looks like in Data Point I only have the option of doing a data compare.

My current work around is to create a single DDL Create a script in Data Point for all of the tables and use another text file comparison tool to identify the changes but this is not optimal.

Hi Steve,

You are right. TDP does not support Schema Compare

Regards

Aleksey

FMS, Inc. has a wonderful product available for schema and data comparisons in JET databases. It is called Total Access Detective (http://fmsinc.com/MicrosoftAccess/DatabaseCompare.html)