Migration Guide

Version Date Notes By
0.2 2019-01-04 Added test server JFM
0.1 2018-01-16 Initial release JFM

SGI

This document assumes you already know what client you are going to migrate

This document contains the steps to start migrating clients from SGIV9 to SGIV10.

This is usually divided in the following steps

  1. Identify the modules that are going to be migrated
  2. Get the current database from the client, if not possible use the development one
  3. Import the database to the test machine (depends on the client)
  4. Analyse the database/modules and document the analysis
  5. Implement the code necessery for the migration
  6. Test the migration (developer)
  7. Create a test machine with the SGIV10 and the migrated data

Documentation

The information of what tables must be migrated, the field mappings and other things related to the database must be documented using Dataedo application.

All other needed documentation must be writen using Grav in documents under Migrations > Cliente

Internal Test Server

IP: 192.168.0.36 SSH User: devel SSH Pass: <check syspass>

MySQL User: devel MySQL Pass: <check syspass>

Legislation

Antes de continuar, garantir que tens toda a informação necessário do cliente, nomeadamente: nivel de subscrição e consultores associados

  1. Ligar por SSH ao servidor antigo de legislação

  2. Sacar as base de dados do cliente

Abrir o ficheiro do apache do cliente para ver o nº da obra

Exemplo: vi /etc/httpd/conf.d/revigres.wemake.pt.conf

mysqldump -u backup -p -h localhost -S /home/obras/<num_obra>/mysql/mysql.sock --single-transaction bw19 | gzip -c > bw19.gz

mysqldump -u backup -p -h localhost -S /home/obras/<num_obra>/mysql/mysql.sock --single-transaction bw03 | gzip -c > bw03.gz

pass: <ver_bitwarden>

  1. Copiar os ficheiros das base de dados

  2. Zipar e copiar os anexos do cliente: zip -9r anexos.zip /home/obras/<num_obra>/framework/legislacao/anexos/

  3. Zipar e copiar os diplomas do cliente zip -9r diplomas.zip /home/obras/diplomas/<nome_cliente>/