CODEWITHSUNDEEP
sqlsql-serverreplicationtransactional-replication
Garry B
Garry B

Reputation: 211

Change Database Structure on Table being Replicated

I need to make structure changes to a database that is part of a subscription that is using Transactional Replication.

I am wondering if I take the Database out of the Article list, make the changes on the Master server then do a Snapshot to reinitialize the subscribers.

Will that work, or is there something else I should do to get this resolved.

Upvotes: 1

Views: 1228

Answers (1)

SPE109
SPE109

Reputation: 2951

I think SQL Server 2005 replicates schema changes as well. See http://technet.microsoft.com/en-us/library/ms151870.aspx

Upvotes: 1

Related Questions