MobiLink Synchronization Wizard in SQL Anywhere 10 - Data Source for the consolidated database schema
(Page 4 of 8 )
You can choose as the data source a database from a number of vendors --Microsoft SQL Server, Oracle, IBM DB2 UDB, SQL Anywhere, and Sybase Adaptive Server Enterprise. For this evaluation the MS SQL Server 2005 on the Windows platform (Windows XP Professional Media Center Edition) will be used. For each of the databases, database-specific scripts add the MobiLink system set up objects needed during deployment (see "objects added in this set up" in Appendix 2 copied from the MS SQL2005 Server Management Studio after the model was created).
Click on the Choose a consolidated database... button to connect to the consolidated database. The "Connect To Consolidated Database" window pops up; in it, you need to provide UserID, Password and the ODBC Source name. When you complete the sub-tasks (completing the authentication process) the consolidated database will finally be chosen and the details shown under the button in the above screen will be filled up.
If this is the first time the DSN was created you may click on the Browse… button which opens showing a list of all user DSNs on the machine as shown in the next picture.
When you click on the OK button, the Dev10 DSN will be available to the authentication window shown earlier. Finally when you click on the OK button with all three items entered, the following window opens.
When you click on the Yes button, the Mobilink message screen shows up, followed by the information about your consolidated database schema updating your earlier screen as shown below. The ownership is shown as that of "dbo" since the credentials entered were those of the dbo. A specific user was not configured for the DSN.
Creating the Remote Database Schema
When you click on the Next button on the above window you will be taken to the next window shown where you can create the schema for the remote database. Since the schema for the remote database has not been created yet, the first option, No, create a new remote database schema is chosen. MobiLink has the ability to create a new UltraLite, or SQL Anywhere database based on an existing consolidated database schema. You may also access an existing remote database instead of creating a completely new remote database schema. Click on the Next button.
This opens up the screen shown in the next picture where you need to identify the objects that need to be included in the schema of the remote database. The objects from the MS SQL 2005 Server database show up in this window. The Customers table which was shown earlier in the MS SQL 2005 Server database 'Test10' is the only table object showing here. It is also possible to have a larger number of tables but for this initial documentation a single table was chosen. The schema for this consolidated database object will be used for the remote database schema definition. By placing a check mark against the table(s), you will be choosing those table(s) for synchronization. Click on the Next button.
Type of download during synchronization
During the synchronization process, all changes to the remote database are uploaded to the consolidated database, and all changes to the consolidated database are then downloaded to the remote database. The changes to the remote database can be determined by examining its transaction log. However, the MobiLink server is not able to access the transaction log of the consolidated database. Hence the data to download from the consolidated database must be determined using a timestamp, custom logic, or by simply downloading the entire dataset. The default, Timestamp-based download is chosen for this evaluation. This option can be changed later, if so desired.
Next: Choosing download options >>
More Database Code Articles
More By Jayaram Krishnaswamy
