Replication

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I replicated my database. Now I no longer want to use replication. How do I remove the replication from my database?
 
Elizabeth,

If you can live with all of the additional replication
fields that are in the original, a simple way is to create a
new database and then to import all of the objects from the
Design Master into it. You would not want to import any of
the system tables or replication specific tables. You will
have to recreate your table relationships. You may have to
live with your GUID fields unless you go to a lot of work to
change all of your PKs.

A cleaner way is to import all of the objects except the
tables and then create MakeTable queries in the DM that will
export the fields you want to new tables in the new db where
you can omit any replication specific fields. You would now
have to set up all your indexing and relationships in all
the new tables.

I have used the first method on a fairly extensive db with
no problems.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
Elizabeth said:
I replicated my database. Now I no longer want to use
replication. How do I remove the replication from my
database?
 
Back
Top