Lesson 1: Setting up your MobiLink consolidated database

Data synchronization requires a MobiLink consolidated database for the UltraLite database to synchronize with. In this lesson, you create a SQL Anywhere database.

Set up a consolidated database

Create a working directory to store the SQL Anywhere database.

This tutorial assumes that you are working in the c:\HelloBlackBerry\database directory.
Run the following command to create an empty SQL Anywhere database:
dbinit HelloBlackBerry.db
Create an ODBC data source to connect to the database.
1. Click Start » Programs » SQL Anywhere 12 » Administration Tools » ODBC Data Source Administrator.
2. Click the User DSN tab, and then click Add.
3. In the Create New Data Source window, click SQL Anywhere 12 and click Finish.
4. Click the ODBC tab.
5. In the Data Source Name field, type HelloBlackBerry.
6. Click the Login tab.
7. In the User ID field, type DBA.
8. In the Password field, type sql.
9. From the Action list, click Start And Connect To A Database On This Computer.
10. In the Database File field, type c:\tutorial\database\HelloBlackBerry.db.
11. In the Server Name fields, type HelloBlackBerry.
12. Disable the Stop Database After Last Disconnect option.
13. Click OK.
14. Click OK on the ODBC Data Source Administrator window.
Run the following command to start Interactive SQL and connect to the SQL Anywhere database:
dbisql -c dsn=HelloBlackBerry

Execute the following SQL statement in Interactive SQL to create the Names table on the consolidated database:

CREATE TABLE Names (
    ID UNIQUEIDENTIFIER NOT NULL DEFAULT newID(),
    Name varchar(254), 
    PRIMARY KEY (ID)
);

Close Interactive SQL.

Click File » Exit.

Discuss this page in DocCommentXchange.