Skip to content

Cbooking DB transfer

Start db-transfer-vm in Azure

From you local machine, run transfer.sh script from attracs-linux-playbooks: * https://github.com/Attracs/attracs-linux-playbooks/blob/6f604ea3e17d5e0289fb341f116ff962ba5ad0a3/scripts/cbooking_transfer/transfer.sh

At first run, just do "Empty src database tables (you will have to export with Cbeaver again after this)"

Then switch to db-transfer-vm in Azure * Start Dbeaver and run one of the tasks * To_cbooking_transfer to copy from org1000Bookings (test) * To_cbooking_transfer_from to copy from org1000Bookings-Live (stable)

Switch back to local machine. Verify that script has correct settings for destination database. Run the script again: * skip emptying (n) * empty destination db (y)

Database should by now moved.