Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data transport from SQL Server to Oracle Expand / Collapse
Author
Message
Posted Thursday, January 24, 2013 1:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 31, 2013 12:49 PM
Points: 6, Visits: 14
Hi,

I want to export some tables from sql server 2008 to oracle 11g. I am planning to use SQL Server Import and Export tool available in SSIS, SQL Server. In order to export and import from SQL Server database to Oracle database, should I pre-create the table structure in Oracle database? Please help.
Post #1411331
Posted Thursday, January 24, 2013 6:04 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
lg123 (1/24/2013)
Hi,

I want to export some tables from sql server 2008 to oracle 11g. I am planning to use SQL Server Import and Export tool available in SSIS, SQL Server. In order to export and import from SQL Server database to Oracle database, should I pre-create the table structure in Oracle database? Please help.


I would pre-create the target table on Oracle database then, probably declare the text file generated by SSIS as an "external table" and just proceed to load it into the target table or whatever the business requirements ask to do with it.


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #1411418
Posted Saturday, January 26, 2013 1:12 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 31, 2013 12:49 PM
Points: 6, Visits: 14
I just tried to start the export/import wizard and it gave me an error. I have attached the error snapshot.

I used windows authentication. I gave the server name and the database name.

I got the below error :

The operation could not be completed. Login failed for user xxxxxx(Microsoft SQL Server Native Client 10.0)


  Post Attachments 
10.png (5 views, 32.69 KB)
Post #1412070
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse