Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Create the SQL Anywhere remote database

To create your remote database

1. Create a directory for this tutorial (for example, OracleTut). Open a command prompt and navigate to OracleTut.

2. Type the following command:

   dbinit remote.db

3. Verify the successful creation of the database by listing the contents of OracleTut.

To create an ODBC data source for the remote database

• While still at your OracleTut directory, type the following command on a single line:

  dbdsn -w test_remote -y 
     -c "uid=DBA;pwd=sql;dbf=path\OracleTut\remote.db;eng=remote"

  Replace path with the location of your OracleTut directory.

To create objects in the remote database

1. Start Interactive SQL.

   Choose Start > Programs > SQL Anywhere 10 > Interactive SQL.

2. Connect to the remote database.

3. Create remote tables, a publication, a user, and a subscription:

   Copy the following code into Interactive SQL and execute it.

   CREATE TABLE emp ( emp_id int primary key ,emp_name varchar( 128 ) );
   CREATE TABLE cust( 
      cust_id int primary key, 
      emp_id int references emp ( emp_id ), 
      cust_name varchar( 128 ) );
   CREATE PUBLICATION emp_cust ( TABLE cust, TABLE emp );
   CREATE SYNCHRONIZATION USER ml_user;
   CREATE SYNCHRONIZATION SUBSCRIPTION
     TO emp_cust FOR ml_user TYPE TCPIP ADDRESS 'host=localhost';

Further reading

For more information about creating SQL Anywhere databases, see Initialization utility (dbinit).

For more information about creating an ODBC data source for a SQL Anywhere database, see Data Source utility (dbdsn).

For more information about Interactive SQL, see Interactive SQL utility (dbisql).

For information about creating the SQL Anywhere objects in this tutorial, see:

• CREATE TABLE statement
• CREATE PUBLICATION statement [MobiLink] [SQL Remote]
• CREATE SYNCHRONIZATION USER statement [MobiLink]
• CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]