Business needs often necessitate data migration from a smaller, less secure database to a higher end, faster database server with a more reliable availability. A typical scenario is the migration of data from a desktop sized database such as MS Access or Fox Pro to any other higher end database servers such as MS SQL Server, Oracle, DB2 or SQL Anywhere Server. Most of the database vendors provide tools to migrate from third party to their own database servers. In his three previous articles, the author has described the built-in tools to migrate from
MS Access to
SQL 2000 Server,
SQL Anywhere Server, and from
Oracle 10G XE to
SQL Anywhere server.Interested readers follow this link:
Migrating MS Access 2003 data using the Oracle SQL Developer 1.2
No comments:
Post a Comment