I have a secured db that is controlled by a mdw file and has about 5 usernames attached, each with a different level of access.
I have created a replica of the database that uses the same security and mdw.
I am having trouble when it comes to the actual syncing of the Master and Replica. I want to have one of the following things occur:
1) When the user closes out of the database, either the Master or Replica, the databases sync OR
2) Another database opens at a certain time, connects to the Master and Replica and syncs them.
I have code for 2) but it fails in the connection as the Master and Replica are secure db's.
So, if someone can suggest a way to do 1) or how to connect the db's as an authorised user I would be most grateful.
Thanks
I have created a replica of the database that uses the same security and mdw.
I am having trouble when it comes to the actual syncing of the Master and Replica. I want to have one of the following things occur:
1) When the user closes out of the database, either the Master or Replica, the databases sync OR
2) Another database opens at a certain time, connects to the Master and Replica and syncs them.
I have code for 2) but it fails in the connection as the Master and Replica are secure db's.
So, if someone can suggest a way to do 1) or how to connect the db's as an authorised user I would be most grateful.
Thanks