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 databaseCreate a new working directory to store the consolidated database.
This tutorial assumes c:\MLsis as the working directory.
Create the SQL Anywhere consolidated database using the dbinit utility.
Run the following command:
dbinit SIS_CarDealer_LP_DBLSN_CONDB |
Start the consolidated database.
Run the following command:
dbeng12 SIS_CarDealer_LP_DBLSN_CONDB |
Define an ODBC data source for the consolidated databaseUse the SQL Anywhere 12 driver to define an ODBC data source for the SIS_CarDealer_LP_DBLSN_CONDB database.
To define an ODBC data source for the consolidated databaseChoose Start » Programs » SQL Anywhere 12 » Administration Tools » ODBC Data Source Administrator.
Click the User DSN tab, and click Add.
In the Create New Data Source window, click SQL Anywhere 12 and click Finish.
Perform the following tasks in the ODBC Configuration For SQL Anywhere window:
Click the ODBC tab.
In the Data Source Name field, type SIS_CarDealer_LP_DBLSN_CONDB.
Click the Login tab.
In the User ID field, type DBA.
In the Password field, type sql.
From the Action dropdown list, choose Connect To A Running Database On This Computer.
In the Server Name field, type SIS_CarDealer_LP_DBLSN_CONDB.
Click OK.
Close the ODBC data source administrator.
Click OK on the ODBC Data Source Administrator window.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |