Patrice Durosay wrote: > Hello > > > We are migrating Base 1.2.27 to Base 2.2.3. > As the db transfert is made through a jdbc, it would be possible to > migrate it to a postgresql db. > > Is it possible, did somebody tried it ?
It should be possible but we have not tested it. If BASE 1 is on MySQL the migration should work as it is. If BASE 1 is on Postgres it is bit more difficult. 1. Copy the 'mysql-migration-queries.sql' to 'postgres-migration-queries.sql' (located in <basedir>/www/WEB-INF/classes). 2. Change the 'sql.queries' setting in 'migrate.properties' to point to the new file. 3. Modify all SQL statements in the new file to make them work with Postgres. Mostly, this means replacing ` with ". There might be other issues that I am not aware of since we are not using Postgres here. If you are successful with this we would very much like to have the file to include it in the distribution. /Nicklas ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
