December 2, 2018 at 12:28 pm
Hi all.
I've never done replication or worked with it, so I've started researching and ran into some questions..
if I set up a replication of a database between two servers and I create or make changes to table structures, views, stored procedures etc. (anything other than modifying the data) will these changes auto replicate across to the subscription server or do I need to manually do these.
Also, when I apply service packs to a replicated environment, do i need to break replication whilst i apply them?
Many thanks in advance.
Dave
December 2, 2018 at 1:42 pm
Hi all,
i think i found half of my answer.
if i make changes to tables or add tables, i need to use SP_AddArticle and SP_DropPArticle to add or drop the table from the publication..
if i have a large amount of changes on a source database, i guess it might be easier to drop the whole replication, blow away the subscription database and re-replicate it??
i'm still not sure about Stored Procedures, functions, views etc.
The environment I have is a stand by server. which contains a SQL server and application. If the main server dies for any reason i want a backup ready to roll.
Thanks
Dave
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply