Does SQL2005 Replication supports Schema changes? - 05-04-2006 , 03:11 PM
I have SQL2005 server running on Win 2003 server. I would like to know if
SQL2005 replication supports schema changes? Both SQL boxes are SQL2005, and
I am looking at specific database (develop database on two different sites)
to replicate from Server A to Server B (one way direction would work for me).
Thanks in advance.
Re: Does SQL2005 Replication supports Schema changes? - 05-04-2006 , 03:21 PM
Yes it does!
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
Looking for a FAQ on Indexing Services/SQL FTS
"SangHunJung" <SangHunJung (AT) discussions (DOT) microsoft.com> wrote
Re: Does SQL2005 Replication supports Schema changes? - 05-04-2006 , 04:32 PM
THanks Hilary, I found your great article "15 tips of replication"
Have a nice day.
"Hilary Cotter" wrote:
Re: Does SQL2005 Replication supports Schema changes? - 05-05-2006 , 03:20 AM
most changes are supported - please see this article:
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book: