Data transport from SQL Server to Oracle

  • 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.

  • 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.
  • 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)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply