The model contains schema for the remote database. This schema can be obtained from an existing remote database or from the consolidated database.
Use an existing remote database in the following cases:
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.
When you deploy your model, you have three options for your remote database, regardless of how you created the remote schema in the model. Your deploy-time options for the remote database are:
Create a new remote database Deployment can create a new remote database using the remote schema from the synchronization model.
Update an existing remote database that has no user tables If you deploy to an empty remote database, then the remote schema from the model is created in the database. This option is useful when you want to use non-default database creation options, such as collation.
For SQL Anywhere databases, you can see a list of options that cannot be set after the database is created in the Remarks section of Initialization utility (dbinit).
For UltraLite databases, database properties cannot be changed after the database is created. See Choosing database creation parameters for UltraLite.
Update an existing remote database that has a schema matching the schema in the model This is useful when you have an existing remote database that you want to synchronize. When you deploy directly to an existing remote database, no changes are made to any existing remote data. If you try to deploy directly to an existing remote database whose schema doesn't match the remote schema in the model, you are prompted to update the remote schema in the model.
For a SQL Anywhere remote database, tables have the same owners as the original database. (UltraLite tables do not have owners.)
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|