April 24, 2003 at 7:19 am
I am wanting to setup Replication between 2
SQL Servers that are not on the same network,
actually they aren't even in the same state.
My concern is security. Some of the data I want to Replicate is sensitive and the
thought of someone getting ahold of any of
the data makes me want to get a new job.
Does anyone know how secure Replication is,
maybe Microsoft has documented it or something, or know of a better way to copy
the data from 1 server to another?
The data only needs to move 1 way, and will
need to be Replicated once a day.
Thanks,
John
April 24, 2003 at 11:08 am
It's only as secure as the link. You could run over a VPN, use SSL, or both. If you only need it once a day, you could build the snapshot, encrypt and ftp to the subscriber, unpack and apply - either instead of or in addition to the VPN/SSL.
Andy
April 24, 2003 at 11:49 am
How would you build the Snapshot outside of
the context of Replication? Would I be
able to do an Export of the tables I want,
encrypt it, ftp it, then Import it on the
other end? How do you do that through a
stored procedure, which I assume it would
have to be done by, since it would be
automated.
John
April 24, 2003 at 12:59 pm
Well, you don't have to do replication. You could just script the tables out once, then you'd have to build code to bcp the data out, encrypt, ftp. Then on the other side run a job to decrypt, bcp in. Snapshot just does that for you, haven't looked to see to what extent you could borrow from it to save some steps.
Andy
April 24, 2003 at 2:35 pm
You also can simulate a transactional replication. You can add fields with datetime data types to capture the changes or create triggers of insert and update to also capture the changes made to the table, and only import those changes with bcp to the text file.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply