Database Update Wizard
How to Transfer Data Between Sybase, Oracle, and Microsoft SQL Server
The Database Update Wizard Transfer out function creates an export data file in a server-independent format (.csv). This means that you can transfer out from a database of one type and into a database of a different type.
To transfer data between different database types, use separate projects, one for each database type. Follow the steps below:
- Log into the project attached to the first database.
- Use the Database Update Wizard to export the tables of interest.
- Log out of the first project.
- Log into the second project attached to a database of a different type.
- Use the Database Update Wizard to import the tables of interest.
Because you specify which tables to transfer, you can specify a partial set of tables. In addition, when you transfer the files in, the Database Update Wizard will just skip the tables for which no extract file (.csv) is found, or for which the extract file is empty.
See Also
Database Update Wizard Overview
Database Update Wizard: Transfer Data Overview