Loading Table from one Database to Another Database

Last post 07-05-2009 11:35 AM by TATWORTH. 3 replies.

Sort Posts:

  • Loading Table from one Database to Another Database

    07-03-2009, 11:28 PM
    • Member
      104 point Member
    • ambrose1
    • Member since 02-05-2008, 8:29 AM
    • Trichy,Tamil Nadu,India
    • Posts 330

    Hello Friends

    I have a table student in Oracle database,Now I want the same table with data to be loaded in sql server 2000.What query I have to use.

    Thanks in Advance

    Winners Never Quit
    Quitters Never Win
  • Re: Loading Table from one Database to Another Database

    07-04-2009, 4:26 PM
    • All-Star
      62,439 point All-Star
    • TATWORTH
    • Member since 02-04-2003, 8:34 AM
    • England
    • Posts 12,183
    • TrustedFriends-MVPs

    Which version of SQL Server 2000 are you using?

    If SQL2000 Standard or better, you can use DTS to copy the table.

    Don't forget to click "Mark as Answer" on the post that helped you.
    This credits that member, earns you a point and marks your thread as Resolved so we will all know you have been helped.
  • Re: Loading Table from one Database to Another Database

    07-05-2009, 6:29 AM
    • Member
      104 point Member
    • ambrose1
    • Member since 02-05-2008, 8:29 AM
    • Trichy,Tamil Nadu,India
    • Posts 330

     Thank u Tatworth,

    Actually I was asked this question by one person,he asked me query..Is there is any query??????...It is for sql server 2000

    Winners Never Quit
    Quitters Never Win
  • Re: Loading Table from one Database to Another Database

    07-05-2009, 11:35 AM
    Answer
    • All-Star
      62,439 point All-Star
    • TATWORTH
    • Member since 02-04-2003, 8:34 AM
    • England
    • Posts 12,183
    • TrustedFriends-MVPs

    The insert script for the Person table in Oracle should work for SQL Server, assuming similar table and column names.

    Don't forget to click "Mark as Answer" on the post that helped you.
    This credits that member, earns you a point and marks your thread as Resolved so we will all know you have been helped.
Page 1 of 1 (4 items)