Your MobiLink consolidated database is a central repository of data and includes MobiLink system tables and stored procedures used to manage the synchronization process. With direct row handling, you synchronize with a data source other than a consolidated database, but you still need a consolidated database to maintain information used by the MobiLink server.
In this lesson, you:
Create a database and define an ODBC data source.
Add data tables to synchronize to remote clients.
Install MobiLink system tables and stored procedures.
If you already have a MobiLink consolidated database set up with MobiLink system objects and a DSN, you can skip this lesson.
In this tutorial, you create a SQL Anywhere database using the Sybase Central Create Database Wizard.
Choose Start » Programs » SQL Anywhere 11 » Sybase Central.
In Sybase Central, choose Tools » SQL Anywhere 11 » Create Database.
Click Next.
Leave the default setting, Create Database On This Computer. Click Next.
In the Save The Main Database File To The Following File field, type the file name and path for the database. For example, c:\MLdirect\MLconsolidated.db. Click Next.
Follow the remaining instructions in the Create Database Wizard and accept the default values. On the Connect To The Database page, clear the Stop The Database After Last Disconnect option.
Click Finish.
The database called MLconsolidated appears in Sybase Central.
Use the SQL Anywhere 11 driver to define an ODBC data source for the MLconsolidated database.
In Sybase Central, choose Tools » SQL Anywhere 11 » Open ODBC Administrator.
Click the User DSN tab, and click Add.
On the Name list, click SQL Anywhere 11. Click Finish.
In the ODBC Configuration For SQL Anywhere 11 window, do the following:
Click the ODBC tab.
In the Data Source Name field, type mobilink_db.
Click the Login tab.
In the User ID field, type DBA.
In the Password field, type sql.
Click the Database tab.
In the Server Name field, type MLconsolidated.
In the Database File field, type c:\MLdirect\MLconsolidated.db.
Click OK.
Click OK.
In this procedure, you create the RemoteOrders table in the MobiLink consolidated database. The RemoteOrders table contains the following columns:
Column |
Description |
---|---|
order_id |
A unique identifier for orders. |
product_id |
A unique identifier for products. |
quantity |
The number of items sold. |
order_status |
The order status. |
last_modified |
The last modification date of a row. You use this column for timestamp based downloads, a common technique used to filter rows for efficient synchronization. |
Connect to your database using Interactive SQL.
At a command prompt, run the following command:
dbisql -c "dsn=mobilink_db" |
Run the following command in Interactive SQL to create the RemoteOrders table.
CREATE TABLE RemoteOrders ( order_id integer not null, product_id integer not null, quantity integer, order_status varchar(10) default 'new', last_modified timestamp default current timestamp, primary key(order_id) ) |
Stay connected in Interactive SQL for the following procedure.
You can find setup scripts for each supported consolidated database in the MobiLink/setup subdirectory of your SQL Anywhere 11 installation.
In this procedure you set up a SQL Anywhere consolidated database. You do this using the syncsa.sql setup script. Running syncsa.sql creates a series of system tables and stored procedures prefaced with ml_. The MobiLink server works with these tables and stored procedures in the synchronization process.
Connect to your consolidated database in Interactive SQL if you are not already connected.
Run the following command:
dbisql -c "dsn=mobilink_db" |
Run the following command in Interactive SQL to create MobiLink system tables and stored procedures. Replace c:\Program Files\SQL Anywhere 11\ with the location of your SQL Anywhere 11 installation.
read "c:\Program Files\SQL Anywhere 11\MobiLink\setup\syncsa.sql" |
Interactive SQL applies syncsa.sql to your consolidated database.
Stay connected in Interactive SQL for the next lesson.
For information about creating SQL Anywhere databases, see Initialization utility (dbinit).
For information about creating tables, see CREATE TABLE statement.
For information about setting up MobiLink consolidated databases, see MobiLink consolidated databases.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |