Results 1 to 3 of 3

Thread: SQL Loader

  1. #1
    Join Date
    Aug 2003
    Posts
    328

    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
    Posts
    41
    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.

    -Sunil.

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    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...

    HTH
    Gregg

Posting Permissions

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