Create Synchronization Model Wizard: Remote Database Schema page

The Remote Database Schema page of the Create Synchronization Model Wizard lets you specify the remote database schema. You can either connect to an existing remote database to obtain the remote schema or you can create a new remote database schema based on the consolidated database schema.

This page has the following components:

  • Do you have an existing remote database   Specifies whether you have an existing remote database to use:

    • No, create a new remote database schema   Choose this option if you want to base the schema of the remote database on the consolidated database. If you select this option, you must later pick tables from the consolidated database to use to create the remote database schema.

    • Yes, use an existing remote database   Choose this option to connect to an existing SQL Anywhere or UltraLite remote database to obtain a remote database schema for the model.

      For example, choose Yes:

      • If you already have a remote database, especially if its schema is not a subset of the consolidated database schema.

      • If your consolidated and remote columns need different types. For example, if you need to map an NCHAR column on the consolidated database to a CHAR column on an UltraLite remote.

      • If your remote tables need different owners from the tables on the consolidated database. For a new SQL Anywhere remote database, the owner of the remote tables is the same as the owner of the corresponding consolidated database tables. If you want a different owner, you should use an existing SQL Anywhere remote database with that table ownership. (UltraLite databases do not have owners.)

      Note

      If you must change the schema of an existing remote database, make the changes to the database outside the model, and then run the Update Schema Wizard to update the model.

      • Choose a remote database   Click this button to choose the existing remote database you want to provide the schema information for the remote database.

        The Connect window appears. Specify the connection information for the remote database.

        Once you have selected a remote database, the following information is displayed:

        • Name   Shows the name of the remote database.

        • User   Shows the user name used to connect to the remote database.

        • Product   Shows the name of the product, for example, SQL Anywhere.

        • Version   Shows the version number of the selected database.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1