SQL Anywhere 11 (Panorama) review guide Part VII_Mssql series tutorials

The routine can pass throughHttp://www.sybase.com/files/Technical_Documents/PanoramaRevGuide.zipDownload
In this document, SQL Anywhere 11 may appear elsewhere as SQL Anywhere Panorama.

Synchronize data with MySQL through MobiLink

Currently, SQL Anywhere 11 supports MySQL 5.0 as a unified database. This supports full two-way synchronization between a remote database using SQL Anywhere or UltraLite and a MySQL 5.0 unified database running the InnoDB storage engine.

MySQL 5.0 synchronization wizard

This Wizard provides a summary of the steps required to set up synchronization between MobiLink and MySQL 5.0. MySQL supported in SQL Anywhere 11 is on Windows (x86/x64) and Linux (x86/x64) platforms.

Prerequisites:

• MySQL 5.0 Community (Community) or Enterprise (Enterprise) servers-official (GA) edition
• MySQL Connector/ODBC driver 5.1.3
• MySQL manager

1. Use the MySQL manager to configure the MySQL database to use the InnoDB storage engine.
2. Create a MySQL unified database sa11. In the command line, browse to the MySQL5.0 _ SA11cons folder of the routine and run the create_db.bat file.
3. Create a MobiLink system table in the MySQL database. Run the create_MLTables.bat file from the same folder.
4. Create a unified database mode, including tables, triggers, stored procedures, and table scripts required for MobiLink synchronization. Run the create_schema.bat file in the same folder.
5. Create an ODBC data source for the MySQL 5.0 database server. Open the ODBC data source manager and add a new user DSN. The content is as follows:

• Data source name: sa11_ML
• Description: MobiLink MySQL Demo
• Server: <your server name>
• Username: root
• Password: SQL
• Database: sa11

Test to ensure that the connection configuration is correct.

6. Start the MobiLink server. Run the setup_MLServer.bat file in the same folder.
7. Create a remote database for SQL Anywhere 11. Run the setup. bat file in the MySQL5.0 _ SA11rem folder of the routine. The script executes the following tasks:

• Create a new SQL Anywhere 11 database
• Create an ODBC data source connected to the SQL Anywhere database
• Start the SQL Anywhere remote database
• Create a remote database mode, including synchronization information
• Insert data into a remote database
• Start The MobiLink client to synchronize new data to the MySQL database

8. Close the first MobiLink client window.
9. Run the sync. bat file in the MySQL5.0 _ SA11rem folder of the routine to insert the new test data to the remote database.

Now you can use the MySQL manager to view the inserted data in the MySQL unified database.

This completes the Wizard. Close the MobiLink client and server dialog box. The following describes how to enable MobiLink synchronization:

• Configure MySQL 5.0 database to use the InnoDB storage engine
• Create a unified database and add a MobiLink system table
• Configure the MySQL Connector/ODBC driver
• Start The MobiLink synchronization server
• Create a remote database for SQL Anywhere 11
• Configure the SQL Anywhere 11ODBC driver
• Insert data into a remote database
• Synchronization