FalconDBSyncSteps

Falcon DB's Information :

IP :192.168.20.241 UserName :kpmduser Password:Medwrite

Databases list to Process :

1. EMRMU2
2. EMRMU2_AuditLog
3. Falcon
4. FalconForTest
5. FalconTesting
6. StageEMRMU2
7. StageEMRMU2_AuditLog
8. EMRMU2_AuditLog

Steps to Sync :

1. Get latest from the git. > git pull
2. In Visual Studio we have to uncheck the ScriptRefreshModule option in general settings.
3. Compare scripts of Falcon and StageFalcon .
4. Then click on Generate script option.
5. After generationg the script we have to copy the script to new query window in DB.
6. Search the script file for the keywords: drop, delete & refresh If any found we have to remove.
7. If any tables modified, then manually write the ALTER commands and add it to the DIFF script files
8. Run the DIFF scripts in the respective Stage databases. Run the Falcon DIFF script in local FalconTesting DB also.
9. Add the newly saved DIFF script files to git. > git add .
10. Commit to git. > git commit -m "Daily DB change script files added."
11. push to git. > git push.
12. Compare Falcon & FalconForTest and update the FalconForTest without generating/saving the script files.