> Hi,
> This database and replication is made couple years ago. Now I need to
> change just one field in the table. Is there any chanse to do this, the
> replication is no longer necessary and DB now have to many data.
> Thanks
If you're sure all replicas have been synchronized and all contain the same
data, you can "recover the design master" from the
"Tools|Replication|Recover Design Master" Menu from any replica you want,
and it will become the design master.
If you want to undo the replication and make it a regular database again,
it's a somewhat tedious process; search for terms like "un-replicating a
database" or similar.>
Cheval - 14 Apr 2005 23:03 GMT
TSI's Unreplicator is the best for unreplicating a replica.
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7
> Hi,
> This database and replication is made couple years ago. Now I need to
> change just one field in the table. Is there any chanse to do this, the
> replication is no longer necessary and DB now have to many data.
> Thanks
If you're sure all replicas have been synchronized and all contain the same
data, you can "recover the design master" from the
"Tools|Replication|Recover Design Master" Menu from any replica you want,
and it will become the design master.
If you want to undo the replication and make it a regular database again,
it's a somewhat tedious process; search for terms like "un-replicating a
database" or similar.>