Merge Replication + Structure Changes

[Martin McNally]

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

[Simon Hayes]

Re: Merge Replication + Structure Changes


"Martin McNally" <mcnally_martin @hotmail.com> wrote in message
news:3cf569e1.0 405031052.574c1 9e9@posting.goo gle.com...[color=blue]
> 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[/color]

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

Simon

[yaniv cohen]

Re: Merge Replication + Structure Changes

mcnally_martin@ hotmail.com (Martin McNally) wrote in message news:<3cf569e1. 0405031052.574c 19e9@posting.go ogle.com>...[color=blue]
> 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[/color]

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