Schema Compare using Data Point

Toad Data Point & Toad Intelligence Central
1

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.

2

Hi Steve,

You are right. TDP does not support Schema Compare

Regards

Aleksey

3

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)