In this lesson, you create a consolidated database named SIS_CarDealer_LP_DBLSN_CONDB with the scripts required for synchronization using the dbinit utility.

To create and start a new SQL Anywhere consolidated database

1. Create the SQL Anywhere consolidated database.

   At the command prompt, use the dbinit utility and specify a file name and path for the database. For example, run the command:

   dbinit c:\MLsis\SIS_CarDealer_LP_DBLSN_CONDB.db

2. Start the consolidated database.

   dbeng11 c:\MLsis\SIS_CarDealer_LP_DBLSN_CONDB.db

Use the SQL Anywhere 11 driver to define an ODBC data source for the database.

To define an ODBC data source for the consolidated database

1. Choose Start » Programs » SQL Anywhere 11 » ODBC Administrator.

2. Click the User DSN tab, and click Add.

3. On the Name list, click SQL Anywhere 11. Click Finish.

4. In the ODBC Configuration For SQL Anywhere 11 window, do the following:

   1. Click the ODBC tab.

   2. In the Data Source Name field, type SIS_CarDealer_LP_DBLSN_CONDB.

   3. Click the Login tab.

   4. In the User ID field, type DBA.

   5. In the Password field, type sql.

   6. Click the Database tab.

   7. In the Server Name field, type SIS_CarDealer_LP_DBLSN_CONDB.

   8. In the Database File field, type c:\MLsis\SIS_CarDealer_LP_DBLSN_CONDB.db.

   9. Click OK.

5. Click OK.

See also

• Creating ODBC data sources