Are there any guidelines for how long it takes to convert high volumes of data from Microsoft SQL Server or Sybase Adaptive Server to an Oracle Server using the Migration Workbench?
No. Performance tests have not been carried out on the data migration process of the Migration Workbench. However, it is known that the setup affects performance. For example, if the Oracle Server and Microsoft SQL Server or Sybase Adaptive Server are not located on the same server, network bandwidth has an affect on performance. Presently, data migration involves reading the data from the source Microsoft SQL Server or Sybase Adaptive Server database through a JDBC/ODBC bridge and writing that data to an Oracle database through JDBC. It is a straightforward data pump. However, the Migration Workbench takes advantage of array inserts and ‘commit points’ to improve performance. You can use the BCP scripts in conjunction with SQL*Loader to provide offline data loading for non-binary data. Data Types The following questions are about SQL Server and Sybase Adaptive Server datatypes.
Related Questions
- Are there any guidelines for how long it takes to convert high volumes of data from Microsoft SQL Server or Sybase Adaptive Server to an Oracle Server using the Migration Workbench?
- What is the Microsoft SQL Server or Sybase Adaptive Server DATETIME data type mapped to within an Oracle database?
- Does SQL Data Compare work with Microsoft SQL Server 6.5/Oracle/Sybase?
