Just to preface this, I am just a developer with some DBA experience but not an expert.
We are migrating from one data-center to another. Basically we are doing this:
- Create a full copy of existing database
- Use the copy to get the target database up to date of the backup.
- Turn on Mirroring from the existing database to the new one.
- The web app will continue to use the existing database ( they are being migrated as well. ) So the old web app server and the new one will both point to the old data center.
ok, after step 4 , we are ready to switch the connection string for the database over to the new one. My concern is… if mirroring is still on and we start to have all read/write operations happen on the target of the mirror… is that going to cause any problems??
ex. say the target of the mirror starts adding rows, will the mirroring catch that the two dbs are not in sync and start removing changes? or… say a row gets deleted in the target db, is the mirror going to catch that it is not in sync and add that row back?
Basically my question is this: If database mirroring is on can we start to read/write to the target of the mirror in preparation for turning the target into the primary database.