Changes between Version 1 and Version 2 of Fr_HowToMigrateTo23

Timestamp:

Apr 11, 2010, 11:48:07 PM (14 years ago)

Author:

fxp

Comment:

--

Fr_HowToMigrateTo23

@@ -25 +25 @@
 INSERT INTO Settings VALUES (90, 1, 'selectionmanager', null);
 INSERT INTO Settings VALUES (91, 90, 'maxrecords', 1000);
-INSERT INTO Settings VALUES (170,1,'shib,'');
-INSERT INTO Settings VALUES (171,170,'use,'false');
-INSERT INTO Settings VALUES (172,170,'path,'/geonetwork/srv/en/shib.user.login');
-INSERT INTO Settings VALUES (173,170,'attrib,'');
-INSERT INTO Settings VALUES (174,173,'username,'REMOTE_USER');
-INSERT INTO Settings VALUES (175,173,'surname,'Shib-Person-surname');
-INSERT INTO Settings VALUES (176,173,'firstname,'Shib-InetOrgPerson-givenName');
-INSERT INTO Settings VALUES (177,173,'profile,'Shib-EP-Entitlement');
-INSERT INTO Settings VALUES (190,1,'userSelfRegistration,'');
-INSERT INTO Settings VALUES (191,190,'enable,'false');
-INSERT INTO Settings VALUES (200,1,'clickablehyperlinks,'');
-INSERT INTO Settings VALUES (201,200,'enable,'true');
-INSERT INTO Settings VALUES (210,1,'localrating,'');
-INSERT INTO Settings VALUES (211,210,'enable,'false');
-INSERT INTO Settings VALUES (220,1,'xlinkResolver,'');
-INSERT INTO Settings VALUES (221,220,'enable,'true');
-INSERT INTO Settings VALUES (600,1,'indexoptimizer,'');
-INSERT INTO Settings VALUES (601,,'600,'enable,'true');
-INSERT INTO Settings VALUES (602,600,'at,'');
-INSERT INTO Settings VALUES (603,602,'hour,'0');
-INSERT INTO Settings VALUES (604,602,'min,'0');
-INSERT INTO Settings VALUES (605,602,'sec,'0');
-INSERT INTO Settings VALUES (606,600,'interval,'');
-INSERT INTO Settings VALUES (607,606,'day,'0');
-INSERT INTO Settings VALUES (608,606,'hour,'24,'');
-INSERT INTO Settings VALUES (609,606,'min,'0');
+INSERT INTO Settings VALUES (170,1,'shib','');
+INSERT INTO Settings VALUES (171,170,'use','false');
+INSERT INTO Settings VALUES (172,170,'path','/geonetwork/srv/en/shib.user.login');
+INSERT INTO Settings VALUES (173,170,'attrib','');
+INSERT INTO Settings VALUES (174,173,'username','REMOTE_USER');
+INSERT INTO Settings VALUES (175,173,'surname','Shib-Person-surname');
+INSERT INTO Settings VALUES (176,173,'firstname','Shib-InetOrgPerson-givenName');
+INSERT INTO Settings VALUES (177,173,'profile','Shib-EP-Entitlement');
+INSERT INTO Settings VALUES (190,1,'userSelfRegistration','');
+INSERT INTO Settings VALUES (191,190,'enable','false');
+INSERT INTO Settings VALUES (200,1,'clickablehyperlinks','');
+INSERT INTO Settings VALUES (201,200,'enable','true');
+INSERT INTO Settings VALUES (210,1,'localrating','');
+INSERT INTO Settings VALUES (211,210,'enable','false');
+INSERT INTO Settings VALUES (220,1,'xlinkResolver','');
+INSERT INTO Settings VALUES (221,220,'enable','true');
+INSERT INTO Settings VALUES (600,1,'indexoptimizer','');
+INSERT INTO Settings VALUES (601,600,'enable','true');
+INSERT INTO Settings VALUES (602,600,'at','');
+INSERT INTO Settings VALUES (603,602,'hour','0');
+INSERT INTO Settings VALUES (604,602,'min','0');
+INSERT INTO Settings VALUES (605,602,'sec','0');
+INSERT INTO Settings VALUES (606,600,'interval','');
+INSERT INTO Settings VALUES (607,606,'day','0');
+INSERT INTO Settings VALUES (608,606,'hour','24');
+INSERT INTO Settings VALUES (609,606,'min','0');
 
 }}}
 
 TODO : Vérifier les interactions avec les noeuds moissonnés (problème d'identifiant)
+
+==== McKoi =====
+===== Connexion à la base de données =====
+ * Télécharger l'utilitaire Druid (http://druid.sourceforge.net/)
+ * Lancer Druid (java -jar druid.jar)
+ * Ouvrir le fichier database.druid situé dans le répertoire gast/setup de GeoSource 2.2
+ * Dans l'onglet JDBC > Connection, 
+  * saisir les informations de connexion pour la base utilisée par GeoSource 2.2
+  * cocher l'option autocommit
+  * cliquer sur connecter
+
+===== Sauvegarde ====
+ * Dans l'onglet structure, faire une sauvegarde de la base :
+  * clic droit sur "JDBC database" > "Export records ..."
+  * sélectionner "Druid data format"
+  * sélectionner un répertoire
+  * un fichier par table est alors créé.
+
+===== Migration ====
+
+
+==== MySQL ====
+
+==== PostGresql ====
+
+==== Oracle ====
+