MySQL to MSSQL INS Database Process Research

mozaude / MozART_ETL

collaboration with IPs and INS for improving MozART submission quality

0 stars 1 forks source link

MySQL to MSSQL INS Database Process Research #7

Open vanamala-narasimhan opened 5 years ago

vanamala-narasimhan commented 5 years ago

Orrin and Mala collaborated with Randy to figure out best process for MySQL to MS SQL conversion of MozART

[x] Met with Randy to figure out status of project
[x] Met with Diogo to understand implications of MySQL to MS SQL move
[x] Weighed possibility of changing everything to MySQL (open source, IP sources are this format)
[x] Determine if MySQL has enough capacity for MozART
[x] Begin process of changing scripts to MySQL -OR-
[x] Investigate tool to convert MySQL to MS SQL
[ ] Draft data checks to QC the chosen process

randyyee commented 5 years ago

Configured MySQL server for access. Both platforms have migration assistants to import as long as there is a source database to connect to (MySQL). Only additional tasks would be appending/merging and recoding.

randyyee commented 4 years ago

MySQL partner backup testing.

Success:

CCS (Romao, Xipamanine) - Restored backup with no issues
ARIEL (Matutuiene) - Restored backup with no issues
EGPAF (Mabil, Ngoabi) - Restored backup. Had to go through the backup to delete DEFINER clauses. Will be an issue with larger backup files. Need to use a utility tool to delete the DEFINER directives or ask partners to export without the DEFINERS line

DEFINER=root@localhost``

Pending:

ICAP (Akumi, Natete) - Submitted wrong files (db export script, not the db backup itself)
FGH - Did not submit any backups