In this lesson, you create a SQL Anywhere remote database, create a synchronization publication, a user, and a subscription. You also create the command file for the MobiLink Listener, and then start the MobiLink Listener.
Create your MobiLink client database using the dbinit command line utility.
Run the following command:
dbinit remote1 |
Start your MobiLink client database using the dbeng12 command line utility.
Run the following command:
dbeng12 remote1 |
Connect to your MobiLink client database using Interactive SQL.
Run the following command:
dbisql -c "server=remote1;uid=DBA;pwd=sql" |
Create the Dealer table.
Run the following SQL script in Interactive SQL:
CREATE TABLE Dealer ( name VARCHAR(10) NOT NULL PRIMARY KEY, rating VARCHAR(5), last_modified TIMESTAMP DEFAULT TIMESTAMP ) COMMIT; |
Create your MobiLink synchronization user, publication, and subscription.
Run the following SQL script in Interactive SQL:
CREATE PUBLICATION car_dealer_pub (table Dealer); CREATE SYNCHRONIZATION USER sis_user1; CREATE SYNCHRONIZATION SUBSCRIPTION TO car_dealer_pub FOR sis_user1 OPTION scriptversion='sis_ver1'; COMMIT; |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |