Create a remote database using an existing database as a model. A schema, remote users, publications, subscriptions, and triggers are also generated.
There are no prerequisites for this task.
Use the Extraction utility (dbxtract) to extract the database schema and data to files. For example, run the following command:
dbxtract -c "UID=DBA;PWD=sql;DBF=c:\cons\cons.db" "c:\remote1\reload.sql" UserName
By default, subscriptions for the specified remote user are started automatically.
Edit the reload.sql, if required.
Create an empty SQL Anywhere database.
For example, run the following command:
dbinit -dba DBA,sql c:\remote1\rem1.db
Connect to the database from Interactive SQL, and run the reload.sql script file.
For example, execute the following statement:
The new remote database, rem1.db, is created with the appropriate schema, remote users, publications, subscriptions, and triggers. However, the Extraction utility (dbxtract) does not start the SQL Remote Message Agent, so no messages are exchanged.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|