Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Location
    East Coast
    Posts
    5

    Question Unanswered: Pulling data from a Oracle database to a SQL Server database

    I have been tasked with pulling data from a clients Oracle database using a SQL Server Stored procedure. I need to know how to point it in the correct direction . Any ideas on a way to set this up as a stored procedure?
    Last edited by Aycex; 03-28-02 at 11:21.

  2. #2
    Join Date
    Mar 2002
    Posts
    2
    You may register Oracle in SQL Server Enterprise Manager, as a linked server, and then use the syntax for distributed queries, in your stored procedure.

  3. #3
    Join Date
    Mar 2002
    Posts
    2
    if you have only to transfert data you can use dts tool

Posting Permissions

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