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.
Sunny

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



"SangHunJung" <SangHunJung (AT) discussions (DOT) microsoft.com> wrote

THanks Hilary, I found your great article "15 tips of replication"

Have a nice day.
Sunny

"Hilary Cotter" wrote:

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)