Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Sybase Central » SQL Anywhere 16 plug-in

 

Comparing database schemas

You can use Sybase Central to compare two databases.

Prerequisites

You must have the SELECT ANY TABLE system privilege in both databases.

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.

 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the two databases you want to compare.

  2. Click Tools » SQL Anywhere 16 » Compare Database Schema.

    The Compare Database Schema window appears.

  3. Specify the two databases you want to compare in the Database 1 and Database 2 fields.

  4. Click Compare.

    The Objects tab lists the summary of the differences between the databases.

  5. 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.

Results

The databases are compared.

Next

Optionally, to convert the schema of Database 1 to match the schema of Database 2, the SQL statements necessary for the conversion appear on the SQL Script tab.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0