Insert Between Two Servers
-
Hello All,
I'm trying to move the data from the processing server over to the production server in order to perform an insert into one table in the production server. the DBA has create an id that allow us to insert into one production table. In order to accomplish this, we have also requested the DBA to linked the production server to the processing server. However, they refused the linked server request. Is there an alternative method to move the data from one server to another to perform the insert without linked server? your help/suggestion is greatly appreciated.
Thank you
-
You could use DTS to export from processing to production, or import to production from processing depending on which server you want to run the DTS.
Far away is close at hand in the images of elsewhere.
Anon. -
Thanks for your respond. But don't you need to add a linked server to the production environment in order to pull the data from the processing environment over?
-
No, you can use the OLE DB driver to connect between servers, it connects the same way as an application would. Linked servers are only necessary for 4 part naming and for using OPENQUERY.
Far away is close at hand in the images of elsewhere.
Anon. -
Depending on the level of control you need, you may be able to just use the icons. But if you need a finer control, use an Active X Script in a DTS package with two connection strings defined, one to each of the servers. We have seen a big performance boost on our imports with that technique.
-
Hi,
use http://www.sqlscripter.com to do that
-
Thank you all for your input/suggestion.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply