Azure automatically pulls changes from this repo. Make sure correct DB connection string is uncommented for production.
Database is deployed, including all data, using DACPAC in ./Database/
folder
- Execute the correct branch of
./Database/Site_alias_change.sql
- Export source DB into DACPAC including data
- In MSMT: right click on target database, select tasks->Upgrade Data-Tier Application and select the dacpac in this folder
If database is too big to fit the free-tier Azure's 32MB limit, clear big tables and shrink database and recreate dacpac