Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Merge Replication + Structure Changes
0 views
Skip to first unread message
Martin McNally
May 3, 2004, 2:52:21 PM5/3/04
to
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.
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
May 3, 2004, 3:06:01 PM5/3/04
to
"Martin McNally" <mcnally...@hotmail.com> wrote in message
news:3cf569e1.04050...@posting.google.com...
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
yaniv cohen
May 18, 2004, 2:57:27 AM5/18/04
to
mcnally...@hotmail.com (Martin McNally) wrote in message news:<3cf569e1.04050...@posting.google.com>...
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:
0 new messages