Results 1 to 3 of 3

Thread: SQL Loader

  1. #1
    Join Date
    Aug 2003

    Unanswered: SQL Loader

    Has anyone ever used SQL Loader to load data from SQL Server tables to Oracle? Is this feasible, or is there a better way to access the Server tables from Oracle?

  2. #2
    Join Date
    Aug 2003
    I have'nt tried it. But using SQL Server Data Transformation Services, you can transfer data between different databases. In the datasource section, you can select your ODBC database. You might need an ODBC connection to your Oracle database.

    And since it is Microsoft, it is all click click and click. whether it works or not.


  3. #3
    Join Date
    Apr 2003
    Greenville, SC (USA)
    Use export on SQLServer side to save to a text file (comma or tab
    delimited. Write a SqlLoader Control file and run SQLLoader ...
    Not too bad.

    You can use the SQLServer export to attach to an Oracle database
    as described, but you may run into some problems if the data
    has date columns (since SQLServer and Oracle store dates differently)
    --- or maybe not ....
    With SQLLoader, you can control the formatting and exceptions...


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts