June 18, 2003 at 8:44 pm
Hey there,
ok, here is the scenario. I have a SQL server which has live data and I am running a DTS package to well synchronize that data every night to a second server. What I am currently doing is truncating the destination table, and the inserting all data from the source server into the destination server. I know that is not efficient and there must be a better way. I do not have any access but select to the source server so i cannot set up a linked server or so. The data is partially updated and new data added on the source.
What is your bet on a better solution?
Thanks a bunch
June 18, 2003 at 9:45 pm
if the table is small, then dts package should be ok, but you may run into issues in the long term.
if you have only select privilege on the source server, you can set up the linked server from the secondary server to the source - provided you have admin privilege.
June 19, 2003 at 7:50 am
The main table has around 180000 records though 2 big text fields (is an incident tracking system). I was not aware that you can setup a linked server from just one machine. I'll give that a shot, thanks. (Though the problem is that the tables are being altered in the DTS process because the source DB has an awful design)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply