This content has been marked as final. Show 5 replies
Which tool did you use to move/migrate the content from SQL Server to Oracle?
To create my table I used SQL developer to convert create table script from SQL server to Oracle.
Note: I have not migrated data from SQL Server to Oracle.
Edited by: 857247 on Jul 13, 2012 4:21 PM
You said you get an error trying to insert data. What is the command or method you are using to move the data ?
Edited by: mkirtley on Jul 13, 2012 3:03 PM
I am just trying to insert data manually using insert statement by copying data from sql server database.
Is there any way where I can migrate data by establishing connection between oracle & SQL server.
I am new to SQL server.
Hi,1 person found this helpful
If it is a one off move of the data then you can use the SQL*developer migration workbench. Have a look here -
You can use this to migrate individual tables if you want to do this.
If you want to use the gateway then have a look at this note in My Oracle Support -
Copying Data Between an Oracle Database and Non-Oracle Foreign Data Stores or Databases Using Gateways (Doc ID 171790.1)
If you are using the copy command and have errors then give us the folloiwng details -
1. The SQL*Server table create statement
2. The Oracle table create statement
3. the syntax you are using for the insert or copy statement
4. The errors you receive