Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Importing and Exporting Data

Extracting databases Next Page

Migrating databases to SQL Anywhere


Using the sa_migrate set of stored procedures or the Migrate Database wizard, you can import tables from remote Oracle, DB2, Microsoft SQL Server, Sybase Adaptive Server Enterprise, and SQL Anywhere databases into SQL Anywhere.

Before you can migrate data using the Migrate Database wizard, or the sa_migrate set of stored procedures, you must first create a target database. The target database is the database into which data is migrated.

For information about creating a database, see Creating a database.

Migrating Access databases

You can migrate Microsoft Access databases to SQL Anywhere using the SQL Anywhere for MS Access Migration utility (upsize tool). You can download this utility at [external link] http://www.ianywhere.com/developer/code_samples/sqlany_migration_utility.html.


Using the Migrate Database wizard
Using the sa_migrate stored procedures