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:
Sql_server_name,1234where 1234 is the custom port.
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:
GRANT CREATE DATABASE TO <the user name>If you cannot login with administrator's privileges, ask your database administrator to do this for you.
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