Groups | Blog | Home
all groups > sql server replication > may 2006 >

sql server replication : Does SQL2005 Replication supports Schema changes?


SangHunJung
5/4/2006 1:11:02 PM
Hello,
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.
SangHunJung
5/4/2006 2:32:02 PM
THanks Hilary, I found your great article "15 tips of replication"

Have a nice day.
Sunny

[quoted text, click to view]
Hilary Cotter
5/4/2006 4:21:49 PM
Yes it does!

--
Hilary Cotter
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?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Paul Ibison
5/5/2006 12:00:00 AM
Sunny,
most changes are supported - please see this article:
http://www.replicationanswers.com/AlterSchema2005.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button