Migrating an MS Access Database to SQL Anywhere with Migration Wizard - The SQL Anywhere Migration Wizard
(Page 4 of 6 )
The SQL Anywhere Migration Wizard can be accessed through the Sybase Central management console as shown in Figure 8. It is of course necessary to start the Sybase Central program. Refer to earlier tutorials for starting Sybase Central. It is assumed that Sybase Central is connected to the mysorian database. If not, you can connect to the database from the menu as discussed in previous tutorials. You may be asked to supply credentials.
When you click on Migrate Database..., the Migrate a Database window shown in Figure 9 pops up. Make sure you read the instructions in this window. You can migrate the schema, or schema and data from an external database through the intermediary of a remote server. The remote server may obtain its data from different kinds of databases, such as DB2, Oracle, MSSQL, and so on. You click Next> on this screen.
The external database will be migrated to an existing SQL Anywhere database. Since mysorian.db is defined as a SQL Anywhere database, it shows itself as an available connected database, as you can see in Figure 10. The name of the server as well as the database happens to be mysorian. Click on the Next> button.
This brings you to the screen shown in Figure 11, where you are asked to create a remote server. You could create a new remote server, or choose from an existing remote server. Click on the Create Remote Server Now... button.
This opens up the next screen, shown in Figure 12. If you create a new one, you may give a name to it. In this case it is called Access Server. Remote servers give access to data located on other databases, such as MSSQL, Oracle, DB2, and so on. Click on the Next> button now.
Next: The SQL Anywhere Migration Wizard, continued >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
