Make a replicated database a regular database

After you've converted a database into a Design Master, you can't convert it back to its former status as a regular database. However, if you no longer want to use replication and want to decrease the size of a replicated database, you can create a new, regular database that contains all of the objects and data in your replicated database without the additional system fields, tables, and properties associated with replication.

Note   For each table in the new database, create the same index used in the replica table. If the s_GUID is a primary key (and foreign keys in other tables refer to it), you'll want the s_GUID field in the new table. If the s_GUID field is not used as a primary key, there is no reason to preserve it in the new table. The s_Lineage and s_Generation fields must not be copied over to the new table.

1. Create a new database, and open it.
   
   
2. On the File menu, point to Get External Data, and then click Import.
   
   
3. Click the replica that contains the database objects that you want in the regular database, and then click Import.
   
   
4. Click the database objects — except tables — that you want to import into the new database.
   
   
5. Click OK to import these objects.
   
   
6. In the new database, create a query for each table in the replica that takes all the data in the old table and puts it into a new table.

   How?

7. For each table in the new database, create the same index used in the replica's table.

   How?

8. For each table in the new database, create the relationships that existed for the replica's table.

   How?

9. Save your new database.