From:       To:      

Oracle to MS SQL FAQ

[Oracle to MS SQL Homepage]  [Download Oracle to MS SQL]  [Buy Oracle to MS SQL]

On this page you can find the most frequently asked questions regarding Oracle to MSSQL converter. If your question is not answered here, please contact us.

What versions of Oracle and Microsoft SQL are supported?
Oracle to MSSQL database migration tool works with all versions of Oracle server including Amazon RDS and other SAAS variations of the DBMS. Also, it supports all versions of MS SQL including Azure SQL.
Go to Top

What are the system prerequisites for Oracle to MSSQL conversion tool?
The program requires that server or client components of Microsoft SQL are installed. It does not require ODBC drivers.
Go to Top

How to specify custom MS SQL port (other than 1433)?
You can specify custom port on 'Step 2 of 6' wizard page in 'MS SQL Server' field as follows:

where 1234 is the custom port.
Go to Top

What if I don't have direct connection to Oracle server?
You need to export Oracle database into dump file using Oracle EXP tool (see manual on this tool). Then you can migrate that dump file to MySQL server using our OraDump-to-MSSQL converter.
Go to Top

Does Oracle to MSSQL converter support automation?
Oracle to MSSQL converter does not support automation directly. However, there is console version of the program o2magent.exe in the installation directory. It supports command line arguments and can be called from any script. So, it is possible to write a simple batch script and execute it recurrently using any Windows scheduler. Please refer to 'Command line' article of the product documentation for the further information.
Go to Top

Is it possible to connect to Azure SQL from Oracle to MS SQL database migration tool?
Yes, the product can connect to Azure SQL. See How to connect to Windows Azure SQL article for related information.

How to proceed with error "ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state"?
This message means that generic error occurred during the conversion process. More detailed diagnostics is not possible because the program converts multiple records per transaction. In order to further investigate the issue you need to send detailed description of the problem via Bug Submission Form
Go to Top

How to resolve error "CREATE DATABASE permission denied in database 'master'"
This error means that you do not have sufficient permissions to create databases on destination MS SQL server. To fix it you need to login with administrator's privileges and run the following statement:

If you cannot login with administrator's privileges, ask your database administrator to do this for you.
Go to Top

How to uninstall Oracle to MSSQL converter?
If you need to remove Oracle to MSSQL product from your computer, use "Add or Remove Programs" option in the Windows Control Panel.
Go to Top