Migrating an MS Access Database to SQL Anywhere with Migration Wizard - Summary of the Migration Procedure
(Page 2 of 6 )
A remote server is created in SQL Anywhere which migrates the data from an external database such as MS Access using an ODBC Connection. The Migration wizard sets up the infrastructure needed to bring this data to a database on a connected SQL Anywhere Server. This is schematically shown in Figure 1 below.
Migrating from MS Access
The sample database that will be migrated to SQL Anywhere from MS Access is a subset of the tables from the Northwind imported into a MS Access database, Migration2.mdb. This is shown in Figure 2.
There exists a set of relationships between the tables, as shown in Figure 3, and there are front-end objects created, such as queries, forms, reports, and so forth, which are not shown. These tables will be migrated to Sybase's SQL Anywhere database.
Migrating to SQL Anywhere
Using command line arguments one can create a database in SQL Anywhere. The database mysorian.db was created by the command line executable dbinit mysorian.db which was given while in the WIN32 directory where Sybase is installed. The detailed description of creating a database that can be used in a web services server has been described earlier.
Next: Creating a SQL Anywhere Server in Sybase Central >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
