February 3, 2008 at 2:56 pm
Hi Guys,
If I change the schema setting in publication, or I change "copy nocluster
index option" from false to true in publication for one table, I remember it
will reinitialize the snapshot and recreate the table schema in subscription.
But I don't remember it will just re-initialiaze this specific table or
re-initialiaze all the tables in this publication. Pleas give me help. Thanks.
February 8, 2008 at 7:58 am
in SQL2005 it is possible to configure the pub for DDL changes, so these will flow through with no extra effort
sp_addpublication @replicate_ddl=1
http://msdn2.microsoft.com/en-us/library/ms151870.aspx
- all clever stuff but arguable whether you want to allow this wobble for PROD environments!
if you did not specify this then such subsequent changes at the pub will not be delivered
- you would have to re-init the pub (all subs, all articles) to deploy your changes
this will likely be rip & replace [which will lose any handcrafted GRANTs etc]
sp_addarticle @pre_creation_cmd='drop'
so you would want to script all the GRANT, CREATE INDEX and any other mods into a xxx.SQL file that you could launch via
sp_addpublication @post_snapshot_script='xxx.SQL'
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply