June 15, 2007 at 9:13 am
Hi there,
I am having problem to export SQL Server tables with data into an Oracle 10g database. I used the Import and Export Wizard to select my desired tables for export, everything went smoothly and the data were exported into the Oracle database. However, SQL Server created the tables and its' columns with a double quote like ("tblEmployee", "EmployeeId"). So when I queried the table, I must put a double quote for the table and column. Is there any way or trick that I can command SQL Server not to use the double quote when creating the tables and columns during data export? I tried to edit the query in the wizard directly but this doesn't work either. Please help! I have been spending 3 hours just for this simple task.
Many thanks in advance,
AC
June 15, 2007 at 9:58 am
Well, I found a work around myself. First import the tables with data and then using SELECT INTO statement to copy data from SQL created tables into Oracle tables. It may not be the best solution but this work for me. Any better suggestion would be appreciated.
Cheers
June 15, 2007 at 11:45 am
Try creating an Oracle Linked server.
* Noel
June 15, 2007 at 8:54 pm
you could export the data using bcp.exe, then import it to oracle using SQL*Loader
---------------------------------------
elsasoft.org
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply