October 3, 2007 at 9:22 am
Is it positble to set replication to have read access only?
October 3, 2007 at 1:08 pm
Read access on the subscriber ?
Can you explain abit more what you really want ?
* Noel
October 3, 2007 at 1:29 pm
i want copy 7 tables from prod to DEV. Have to refresh every week.
October 3, 2007 at 3:02 pm
Replication is a bad choice for doing that. You should use BCP, SSIS or SMO instead.
* Noel
October 3, 2007 at 6:40 pm
why replication is not a good choice ?
what is SMO?
October 4, 2007 at 8:18 am
Replication is not a good choice to do that because the overhead that you are going to put in production is not necessary. If you use transactional, for example your Transaction log won't shrink untill all transactions have propagated to the subscriber (DEV in this case). when doing a snapshot all tables will be locked unless you use concurrent snapshot or database snapshot mode but those have also extra requirements.
SMO: SQL Server Management Objects.
* Noel
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply