Migrating an MS Access Database to SQL Anywhere with Migration Wizard

(Page 1 of 6 )

This tutorial describes in detail the use of the Sybase specific Migration Wizard to migrate an MS Access Database to SQL Anywhere. SQL Anywhere commands an important position in mobile linkages because of its excellent synchronization, and in this context, moving to this platform may have some advantages.Introduction

This is the fourth tutorial I've written in a series on import/export, or migration of databases, both for Microsoft and non-Microsoft products. The reader will be profited by reviewing these tutorials. The reasons why one might want to migrate have already been discussed in the earlier tutorials.

In importing into MS Access from SQL 2000 Server, a detailed step by step process to bring in data from SQL Server to MS Access using ODBC connectivity was described. In MS Access migration to SQL 2000 server, details of how data is migrated to SQL Server while keeping the front-end functional in MS Access were discussed. In the third tutorial a migration from / to Microsoft and non-Microsoft databases was described.

In all three tutorials either Microsoft's DTS tool or MS Access' native Link Tables to get external data were used. In the linked case, ODBC connectivity was used to connect to the database. The tables in SQL Server remained in their original location, but that data was accessible from the front-end. The present tutorial uses Sybase's Migration Wizard to migrate the database from MS Access to the SQL Anywhere database. The tutorial describes in detail how this is accomplished. Since the migration involves different types of databases, the tutorial also reviews how the data is migrated.

Next: Summary of the Migration Procedure >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: Migrating an MS Access Database to SQL Anywhere with Migration Wizard

· Growth requires migration as it is the key requirement as well as the main driver....   >>> Post your comment now!