Change table schema in replicated tables

Donzella
Donzella used Ask the Experts™
on
We are considering upgrading to SQL 2008 from 2000. The biggest anticipated reason is improvements to replication. One thing that I've read but wanted to confirm with someone who actually knows for sure is that I can make changes to table schema in tables being replicated without having to take them out of replication and reinitialize everything... and that the changes will propagate to the subscribers. Is this actually true? Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Awarded 2008
Awarded 2008
Commented:
I believe this is the case...but that was the case in 2005.  You should be able to do this in 2005 and it work just fine

alter table tablename
add fieldname int

Author

Commented:
You are saying that you know it worked in 2005 for sure? I just have to be sure because it's important to the man with the checkbook paying for the upgrade. :)
Awarded 2008
Awarded 2008

Commented:
I am next to 100% sure.  

You can always install and test and see....you don't have to buy as soon as you install.

Author

Commented:
Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial