Recover Replica - Help

[Grumm]

I have created a master database for a customer and set up a number of replicas which were working fine.

The customer has now changed their mind and want to run the system centrally. I want to convert the master back to a 'non' replica version without the large ID's in the keys and the extra 'replica ' columns in each table.

How can I do this - I am really struggling.

 

[pepperca]

You will need to create a new database and import into it. What I did with my tables is export the replica version to excel and delete the replica fields then import these into the new database.

Hope this helps.

Cindy