var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
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.