January 13, 2003 at 12:22 pm
Hi,
Every night, new records in several tables on an off site SQL box needed to be copied over to an in house SQL box. At first I was planning to create a linked server and schedule a job to copy new recoreds to the in-house box. However I think it'd be better to schedule a job on off site SQL box to copy new records to a new table; DTS the new table to the in-house SQL box; schedule a job on in-house box to import new records to local tables. Is it better (from security view) to have DTS runings VS. linked server?
Thx.
January 13, 2003 at 12:31 pm
The big thing with Linked Servers is that you can inadvertently create security holes on remote servers if you do not setup properly. As for DTS thou it also has been iterfaces for passing the data. However, depending on the admins of the offsite server I personally would build the DTS package inhouse just in case any try to snoop it makes it harder. But with the fact you create connection items in DTS I would make sure to setup an account for this specific need and password protect the design with a owner password and setup a user password so someone else could execute without need oto know anything more.
January 13, 2003 at 12:50 pm
I also admin the off site box. The account used to setup linked server has just READ permission to the tables. Thanks for your input.
January 13, 2003 at 2:42 pm
if this case i would use dts send the data over. I think the maintenance of the dts packet, if you change servers or want it to be on a backup server. Linked servers are kind of hidden to another dba.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply