How to extract data from one database to another

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • reany
    New Member
    • Sep 2007
    • 1

    How to extract data from one database to another

    i want to get know about "How to extract data from one database to another".?

    pls reply me as soon as possible.
    thanks !
  • vijaii
    New Member
    • May 2007
    • 15

    #2
    Originally posted by reany
    i want to get know about "How to extract data from one database to another".?

    pls reply me as soon as possible.
    thanks !

    SELECT * FROM DatabaseName..T ableName

    Comment

    • amitpatel66
      Recognized Expert Top Contributor
      • Mar 2007
      • 2358

      #3
      Originally posted by reany
      i want to get know about "How to extract data from one database to another".?

      pls reply me as soon as possible.
      thanks !
      You can create Database Link in case if you want to query the data from the table of another database.

      Comment

      • ck9663
        Recognized Expert Specialist
        • Jun 2007
        • 2878

        #4
        Originally posted by reany
        i want to get know about "How to extract data from one database to another".?

        pls reply me as soon as possible.
        thanks !
        or do a DTS (import/export) in Enterprise Manager

        Comment

        Working...