Versions Compared

Old Version 15

changes.mady.by.user Unknown User (njo@kvalitetsit.dk)

Saved on

compared with

New Version 16

changes.mady.by.user Unknown User (njo@kvalitetsit.dk)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

./migrate-to-staging.sh



Navitabs
rootNSP XDS Registry (NXRG) - Leverancebeskrivelse


...

Afvikling af migreringen

Migreringen afvikles ved blah blah blaher i to faser: Fra opentext-databasen til staging-databasen, og fra staging-databasen til nxrg-databasen.

Første fase køres med kommandoen

./migrate-to-staging.sh

(fra roden af nxrg-projektet).

Anden fase består i at eksportere data fra staging-databasen, og importere dem i nxrg-databasen. For at eksportere data køres følgende fra mysql-konsollen:


select * from associationcontent into outfile '/data/associationcontent.out';

select * from associations into outfile '/data/associations.out';

select * from authors into outfile '/data/authors.out';

select * from codes into outfile '/data/codes.out';

select * from documententries into outfile '/data/documententries.out';

select * from documententry_author into outfile '/data/documententry_author.out';

select * from documententry_confidentialitycode into outfile '/data/documententry_confidentialitycode.out';

select * from documententry_eventcode into outfile '/data/documententry_eventcode.out';

select * from documententry_referenceid into outfile '/data/documententry_referenceid.out';

select * from documententrycontent into outfile '/data/documententrycontent.out';

select * from foldercontent into outfile '/data/foldercontent.out';

select * from folders into outfile '/data/folders.out';

select * from referenceids into outfile '/data/referenceids.out';

select * from submissionsetcontent into outfile '/data/submissionsetcontent.out';

select * from submissionsets into outfile '/data/submissionsets.out';

Man kan evt. tilpasse stien som filerne skrives til.


./migrate-to-staging.sh


Logning af fejl

Migreringen logger eventuelle fejl til en logfil (som udgangspunkt nxrg-migration.log, kan konfigureres med log4j.properties), som kan analyseres efter at migreringen er kørt.

...