Merge Replication + Structure Changes

My company maintains 40 replicated Sybase databases using a merge
replication approach. It's difficult to update all 40 databases when a
structure change occurs. Structure changes are minor, usually adding
fields.

We are considering moving to SQL Server 2000 in the hope that these
updates will be easier to do. Does SQL Server 2000 support structure
updates accross replicated databases?

Martin"Martin McNally" <mcnally_martin@.hotmail.com> wrote in message
news:3cf569e1.0405031052.574c19e9@.posting.google.c om...
> My company maintains 40 replicated Sybase databases using a merge
> replication approach. It's difficult to update all 40 databases when a
> structure change occurs. Structure changes are minor, usually adding
> fields.
> We are considering moving to SQL Server 2000 in the hope that these
> updates will be easier to do. Does SQL Server 2000 support structure
> updates accross replicated databases?
> Martin

MSSQL supports adding or dropping columns while using any type of
replication. You might want to post this in
microsoft.public.sqlserver.replication, as people there may be able to give
more detail about any common issues or disadvantages.

Simon|||mcnally_martin@.hotmail.com (Martin McNally) wrote in message news:<3cf569e1.0405031052.574c19e9@.posting.google.com>...
> My company maintains 40 replicated Sybase databases using a merge
> replication approach. It's difficult to update all 40 databases when a
> structure change occurs. Structure changes are minor, usually adding
> fields.
> We are considering moving to SQL Server 2000 in the hope that these
> updates will be easier to do. Does SQL Server 2000 support structure
> updates accross replicated databases?
> Martin

hello martin!!

Try dbMaestro. It's a product that allows comparison, migration and
archiving of database schema and data in Sql Server 2000. by migration
you can updates structures of databases and data.

You can find it here:

http://www.extreme.co.il