[WIP!!]
Backup DBs. Use the BackUpInsightsPlusDatabase.ps1 script of the Scripts Repo. This will backup sqldb-products, sqldb-insightsdata, sqldb-analyzer, and sqldb-certificationo.
NOTE: Eventually we need to move each of these to their own “release” instructions to be able to release each independently and create migration projects for each. This will require a stricter adherence to API schemas! Then this will become exclusive to the insights+ DPL code and the products code and DB.
- Compare Schemas on sql-nswers-01
- sqldb-analyzer
- sqldb-certification
- sqldb-products
- sqldb-utility
- Compare Schemas between sql-nswers-01 (staging) and uploads.database.usgovcloudapi.net (production)
- sqldb-filestatus
- sqldb-secureutilities
HINT: Use the VS Sql Schema Compare Scripts in the DBCompare folder of the Scripts Repo. Make sure to review the changes and update the script to exclude irrelevant items. One area to pay special attention to are indexes and foreign keys. Azure will auto generate some of these as needed and so should very likely not be synchronized. Typically these can be identified by a non “human-friendly” looking name (i.e. FK__Certifica__Paren_02FC7413). Since the names are automatically generated, there will often be two differences detected – one on the source and one on the target, but upon inspection they are actually the same.
- PR NSWERS.Research.DbUp into master
Leave a Reply