November 6, 2007 at 8:18 am
When moving a new build to a database, one of my steps is to refresh all the reference tables. I usually run a script that disables all triggers and constraints, deletes the data, then inserts it back.
Disabling the triggers work but when it tries to disable constraints, it gets hung. Do I need to remove the reference tables as table articles, run the script, and then add them back as articles?
Any help would be appreciated.
Brent
November 6, 2007 at 2:51 pm
Definitely drop subscr, drop article, alter table, add article, add subscription. Run snapshot agent - if transactional repl snapshot only generated for affected tables.
Otherwise if you get around your "hung" problem - when you issue a "delete from mytable" and there are 1 million records - you will not replicate 1 delete command. YOu will replicated 1 million individual delete commands, then the insert will replicate 1 million individual insert commands. Not a good practice on large tables, also not good if done duing peak usage.
ChrisB MCDBA
MSSQLConsulting.com
Chris Becker bcsdata.net
November 6, 2007 at 4:22 pm
I thought running the snapshot agent with peer-to-peer replication was a one-time operation. I remember an error dialog box appearing when I tried to do so before.
Please clarify.
Thanks,
Brent
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply