Replication Problem

MDDDS

Registered User.
Local time
Today, 12:20
Joined
Oct 17, 2003
Messages
10
I have a Design Master that I use for many replicas. I would like to replicate the design master so experimental changes to queries and tables can be conducted without exposing the "real design master" to errors? Each time I replicate/copy the design master the replica/copy will not allow changes. Is there a way to disassociate the copy/replica from the Design Master so experimental changes will be allowed and can be made?
thanks
 
You couls copy the design master to an other folder (include tehe secured file as well)
open the copy using the shift key
tools
replication
recover design master

you now have two design masters (in seperate folders)

you can now amend one and do testing and then export these changes to the other design master.

Some may not recommend this as you may have problems administering the Two design masters and replicas.
You will notice that when you recover the design master the prompst that appear don't recommend having two design masters
 
In a new folder, create a new blank database. Import from the existing master database all tables, queries, etc. You can now make changes in the new database. Just keep track of all the all the queries, reports, etc. Then when you're done, import the new queries, reports, etc. into your master database.
 

Users who are viewing this thread

Back
Top Bottom