Run the following commands to create a remote database and start it running:

cd..
md c:\remote
cd c:\remote
dbinit remote.db
dbeng12 remote.db

Open another instance of Interactive SQL and connect to remote.db.

dbisql -c "eng=remote;dbf=remote.db;uid=dba;pwd=sql"

Run the following SQL in Interactive SQL to create objects in the remote database.

First, create the table to be synchronized.

CREATE TABLE customer (
   id      unsigned integer primary key,
   name    varchar( 256),
   phone   varchar( 12 )
);

Still using the Interactive SQL instance connected to the remote database, create a publication, MobiLink user and subscription. Notice that the script version is associated with the subscription using the SCRIPT VERSION clause. This is very important since the schema upgrade procedure shown in this tutorial only works for subscriptions that have the script version set using the SCRIPT VERSION clause.

CREATE PUBLICATION p1 (
      TABLE customer
);

CREATE SYNCHRONIZATION USER u1;

CREATE SYNCHRONIZATION SUBSCRIPTION my_sub
TO p1
FOR u1
SCRIPT VERSION 'my_ver1';