Building CustDB as a consolidated database (Adaptive Server Enterprise, MySQL, Oracle, SQL Server)

The following procedure creates a CustDB consolidated database for any of the supported RDBMS.

Prerequisites

You must have access to the SQL scripts that are used to build the CustDB consolidated database as one of the supported RDBMSs. The SQL scripts are located in %SQLANYSAMP16%\MobiLink\CustDB.

Task

Create a database in your RDBMS.
Add the MobiLink system objects by running one of the following SQL scripts, located in the MobiLink\setup subdirectory of your SQL Anywhere 16 installation:
- For an Adaptive Server Enterprise consolidated database, run syncase.sql.
- For a MySQL consolidated database, run syncmys.sql.
- For an Oracle consolidated database, run syncora.sql.
- For a SQL Server consolidated database, run syncmss.sql.
Add sample user tables, stored procedures and MobiLink synchronization scripts to the CustDB database by running one of the following SQL scripts, located in %SQLANYSAMP16%\MobiLink\CustDB:
- For an Adaptive Server Enterprise consolidated database, run custase.sql.
- For a MySQL consolidated database, run custmys.sql.
- For an Oracle consolidated database, run custora.sql.
- For a SQL Server consolidated database, run custmss.sql.
Create an ODBC data source called CustDB that references your database on the client computer.
1. Choose Start » Programs » SQL Anywhere 16 » Administration Tools » ODBC Data Source Administrator (32 or 64 bit).
2. Click Add.
3. Select the appropriate driver from the list.
  
  Click Finish.
4. Name the ODBC data source CustDB.
5. Click the Login tab. Enter the User ID and Password for your database.
Click OK and then click OK again.

Results

A CustDB consolidated database is created for the selected RDBMS.

Discuss this page in DocCommentXchange.