------------------------------------------------------ |01 RTA Data Migration Process updated on 01-06-2023 | ------------------------------------------------------ cd ---------------------------------------------------- |02 Create Data Source Dump and staging database | ---------------------------------------------------- mysqldump -uroot -p prod_rta > test_tra_30_05_2023.sql scp -P 23 u270633@u270633.your-storagebox.de:/home/home/rta/pland_prod29-05-2023.psql.gz . gunzip pland_prod29-05-2023.psql.gz su - postgres psql \c prod_rta DROP SCHEMA public CASCADE; CREATE SCHEMA public; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO public; PGPASSWORD=pland psql -d prod_rta -U pland -f pland_prod29-05-2023.psql --------------------------------------- |03 Run Data Mapping | --------------------------------------- PGPASSWORD=pland psql -d prod_rta -U pland -f sql/psql_migration_prep.sql --------------------------------------- |04 Run Database cleaup | --------------------------------------- cd /var/www/html/prod_rta mysql -uroot -p prod_rta < sql/cleanup.sql ------------------------------------ |05 Update database tables | ------------------------------------ php artisan migrate ------------------------------------------ |06 Invoke Migration Script in Application| ------------------------------------------ Open rta2.0 app in web browser and run the migration job https://rta2.puntlandgov.org/en/login https://rta2.puntlandgov.org/en/migrate i) Execute ----> All [Caution-> This may result in memory limit issue] OR ii) Step By Step: Recommended -------------------- 1.config 2.sticker 3.vehicle 4.party 5.title 6.tax ------------------------------------------------------------------- |07 Execute Master Configurations and Cleanup of Master Data files | ------------------------------------------------------------------- mysql -uroot -p prod_rta < sql/post_migration_cleanup.sql