This page allows you to specify whether you want to deploy the synchronization model to a command file and SQL file that you can run later to update the remote database or connect to the remote database and update it immediately.
If you are using central administration of remote databases, you should choose to create a SQL file that can later be used in a remote task.
This page has the following components:
How do you want to deploy to the remote database Choose one or more of the following options:
Save changes to the following SQL file (and create a command file in the same folder) Select this option to specify the name and location of the SQL file, or click Browse to select the file. The command file is created in the same location.
Include SQL commands to create the remote schema Select this option to include SQL commands to create the remote schema. This option allows you to overwrite existing schema. If you deploy using this option, then tables in the existing remote database that have the same names as those in the model will be dropped and recreated. This option only applies if you are not connecting to the remote database to directly apply the changes.
Remote database type Choose SQL Anywhere or UltraLite from the dropdown list to specify the remote database type.
Connect to the remote database to directly apply the changes Select this option to deploy the synchronization model directly to a remote database. The existing database schema must match the remote database schema in the model.
Choose a remote database Click to choose the remote database that you want the synchronization model deployed to. The Connect window appears. Specify the connection information for the remote database.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|