Replication (or Not)

[Martyh]

Hi,

I have received a replicated db --- that is all
(not a master) I want to know if any one has experience in "unreplicating"
a db and what steps I take to unreplicate this db. I know (more or less) what replication does for you, but I have never done it !!

TIA

Marty

 

[Pat Hartman]

I have seen an article that talks about this. You may even find a help entry on the topic. Search the Microsoft knowledgebase and the MSDN library.

 

[Smart]

You can change the replicated database to a design master as follows

Open the replicated database
On the tools menu select
replication
Recover design master
click yes on message box
click yes on message box
click Ok on message box
the database is now a design master
if you really need an un replicated dbase
create a blank database and import everything from the design master

 

[Martyh]

Thanks guys!

I now have experience with an unreplicating add-in that seems to work quite well -- it seems to remove all the added fields from the tables etc. Take a look at http://www.trigeminal.com/lang/1033/utility.asp?ItemID=11#11 which explains the solution in great detail.

A Happy Camper --

Marty