The Deploy wizard provides two options for deploying to the consolidated database:
Apply your model directly to your consolidated database by populating MobiLink system tables and creating all required shadow tables, columns, triggers, and stored procedures. It also optionally creates batch files to run your MobiLink application.
Create a SQL file that contains all the same changes. You can inspect this file, alter it, and run it anytime. The effect is identical to applying the changes directly.
You can choose to use an existing remote database or have the wizard create one for you. The wizard can create remote databases directly or you can have it create a SQL file that creates the remote databases.
The wizard creates a remote database (either SQL Anywhere or UltraLite) with default database creation options using the database owner that you specified in the model. Alternatively, you can create a remote database outside of the Create Synchronization Model wizard with your own custom settings and use the wizard to add the required remote tables, or you can deploy to an existing remote database that already has the remote tables.
A batch file to run the MobiLink server with options that you specify.
For SQL Anywhere remote databases, a batch file to run dbmlsync with options that you specify.
For UltraLite remote databases, a batch file to run ulsync with options that you specify. Ulsync is used for testing synchronization, so it helps you get started when you don't have a working UltraLite application.
If you are setting up server-initiated synchronization, the Deploy Synchronization Model wizard can also create batch files to run the Notifier and the Listener.
After deploying a model, you can alter it. The best way to alter the model is to make changes in Sybase Central Model mode and then re-deploy it. You can also alter your deployed system in Sybase Central Admin mode or by directly changing the database using system procedures or using other methods. However, when you alter a deployed model, you cannot reverse-engineer it back to the model.