SOP for Publishing Database updates

Overview

The instructions below contains the list of actions that need to execute to be able to sync database updates to live server. There are separate instructions for updating client databases and updating the master/system database.

Pre-requisite

1. Any changes applied on the databases, either on ReserbizDeveloper or dbReserbizSYSSQL databases, are being tracked by the migration files which can be found on ReserbizAPP.LIB project and this needs to be published first. Reserbiz Web API project has reference to this library project so this should be deployed first. To deploy the web API, follow the procedures on this github wiki page https://github.com/RoiJS/Reserbiz/wiki/SOP-for-Publishing-Web-API.

Sync dbReserbizSYSSQL database

1. Open Postman application and open request tab named "Sync Database" (Go to Reserbiz Application -> System Db Manager -> Sync Database).
2. Make sure that the request URL is pointing to the live server (reserbiz.com/api).
3. Click the Send button.
4. Verify that the changes on the database were successfully synced.

Sync client databases

One can deploy database updates on a specific client database or for all client databases. Refer to the instructions below

Sync specific database

1. Open Postman application and open request tab named "Sync Database" (Go to Reserbiz Application -> Client Db Manager -> Sync Database).
2. Make sure that the request URL is pointing to the live server (reserbiz.com/api).
3. Click the Send button.
4. Verify that the changes on the databases were successfully synced.

Sync all databases

1. Open Postman application and open request tab named "Sync Database" (Go to Reserbiz Application -> Client Db Manager -> Sync All Databases).
2. Make sure that the request URL is pointing to the live server (reserbiz.com/api).
3. Click the Send button.
4. Verify that the changes on the databases were successfully synced.