Results 1 to 5 of 5

Thread: Connecting Sql Server with Oracle Database to get data information

  1. 06-16-2010, 07:44 AM #1
    yemiit
    yemiit is offline Registered User
    Join Date
    Jun 2010
    Posts
    2

    Connecting Sql Server with Oracle Database to get data information

    Am trying to Pull Data out of an Oracle Database into Sql Server 2005 or 2008
    Reply With Quote Reply With Quote
  2. 06-16-2010, 09:44 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Try with ssis or linked server.
    Reply With Quote Reply With Quote
  3. 06-16-2010, 10:32 AM #3
    yemiit
    yemiit is offline Registered User
    Join Date
    Jun 2010
    Posts
    2
    Can you please try to Explain to process in using the ssis and the linked server.
    Reply With Quote Reply With Quote
  4. 06-16-2010, 02:36 PM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    On Management Studio right click on any database and go to Tasks - Import Data, the wizard will guide you next.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
  5. 06-17-2010, 07:41 AM #5
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    And books line has details of those.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules