Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Unanswered: How to copy data across databases

    I am trying to copy information from one Database to another. Each of the databases reside on a different server.

    My question is
    1. How can I use the DSN name in a stored procedure?
    2. Do I need to use dynamic SQL?
    3. Any other ideas of how to implement this?

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    My first suggestion would be the Data Transformation Service.

    A good second best would be a Linked Server, which could use a DSN if you like.

    If raw transfer performance is your primary goal (and you are willing to learn quite a bit to get it), then Bulk Copy will get you the fastest transfer rate.

    -PatP

Posting Permissions

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