Before you embark down the replication path, what need are you trying
to serve? Replication may or may not be the right answer depending.
It sounds like your need may be to have a backup copy at your co-lo,
in which case log shipping or mirroring might serve you better.
But, to answer your question, some schema changes are handled
automatically while others aren't. For instance, adding a new table
to the published database isn't handled automatically, but changes to
already replicated tables are (assuming you've configured it for
We have 2 SQL 2005 servers. One in the local office and a Second at a co-lo
in another state.
What I am needing to do, to replicate the local one, to the co-lo. I am
thinking that Transactional would be best as it would keep an almost realtime
The part I am not sure about, is if we add a table, or modify a table, will
that change get replicated out as well?