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? Specify 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 to have different types. For example, if you need to map an NCHAR column on the consolidated to a CHAR column on an UltraLite remote.
If your remote tables need to have 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 your desired table ownership. (UltraLite databases do not have owners.)
If you need to change the schema of an existing remote database, make the changes to the database outside of 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 dialog appears. Specify the necessary information to connect to the remote database. The following fields are all blank until you specify a consolidated database, and then they are updated to show the information for the selected consolidated database:
Name Shows the name of the remote database.
User Shows the user name of the user connected to the remote database.
Product Shows the type of the remote database, SQL Anywhere or UltraLite.
Version Shows the product version.