MobiLink Synchronization User's Guide
  Tutorial: Using MobiLink with an Oracle 8i Consolidated Database
    Lesson 1: Create your databases

Databases

In this procedure, you build a consolidated database using the dbisql command line utility. The dbisql utility helps you to execute SQL commands within your database. This procedure executes SQL statements within each database.

For more information about dbisql, see The Interactive SQL utility.

To create and populate tables in the consolidated database

1. Start SQL Plus and connect to your consolidated database. Choose Start > Programs > Oracle - OraHome81 > Application Development > SQL Plus.

2. Execute the SQL statements in build_consol.sql by running the following command:

   @c:\OracleTut\build_consol.sql;

   Replace c:\ with the location of your OracleTut directory. If the path contains spaces, enclose the path and filename in double quotes.

3. Verify the successful creation of each of the tables through SQL Plus directly from within the application. Run the following SQL statements:

   SELECT * FROM emp;
   SELECT * FROM cust;

4. Leave the consolidated database running.

To create tables and synchronization information in the remote database

1. Open a command prompt and navigate to your OracleTut directory. Run the following command line:

   dbisql -c "dsn=test_remote" build_remote.sql

   The dbisql plug-in starts the remote database and executes the SQL statements in build_remote.sql.

2. Verify the successful creation of the emp and cust tables using Interactive SQL or Sybase Central.

3. Leave the consolidated and remote databases running.