Changes between Version 1 and Version 2 of HowToMoveFromMySQLToPostgres

Timestamp:

Jul 10, 2009, 4:24:00 AM (15 years ago)

Author:

heikki

Comment:

--

HowToMoveFromMySQLToPostgres

@@ -49 +49 @@
  }}}
 
+=== Database create scripts ===
+
+!GeoNetwork comes equipped with a create-database script for various DBMSes, also for Postgres. This one should do fine for a standard !GeoNetwork installation.
+
+In our case however, the installation is a modified version of !GeoNetwork ([http://www.nationaalgeoregister.nl the Dutch géoportail]). It uses an alter-database script to create some changes idiosyncratic to this project. This file is developed against MySQL. In this file I had to make some changes :
+
+ * change {{{int(10)}}} to {{{int}}}
+ * change {{{LONGTEXT}}} to {{{TEXT}}}
+ * change {{{datetime}}} to {{{varchar(24)}}}
+ * change {{{double}}} to {{{float8}}}
+
+The change for {{{datetime}}} is debatable, as there also is a Postgres {{{timestamp}}} datatype. We may switch to that.
+
 
 === creating a database and user ===
@@ -81 +94 @@
 
 
-=== Database create scripts ===
-
-TODO describe the changes 
-
 === Exporting existing data from MySQL and importing it into Postgres ===