You can use Sybase Central to compare the schema of two databases.
There are no prerequisites for this task.
Context and remarks
When comparing databases, objects are not matched by object ID but by name, name and owner, or a combination of names and owners.
In Sybase Central, use the SQL Anywhere 12 plug-in to connect to the two databases you want to compare.
Click Tools » SQL Anywhere 12 » Compare Databases.
The Compare Databases window appears.
Ensure that the two databases you want to compare are specified in the Database 1 and Database 2 fields.
The Objects tab lists the summary of the differences between the databases.
Click an item on the Objects tab to view the SQL statements for the object. A red background indicates SQL for objects that exist in Database 1 only, a green background for objects that exist in Database 2 only, and a blue background for objects that exist in both databases.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|