Hi, We are doing some preliminary migrations on testing databases to test if everything works fine with the migration script. We use Postgres 7.3.9 on both, Base1 and Base2 installations, so we will test how it works with this db server. Except changes required by Postgres in /migration-queries.sql/ file I found that in method /net.sf.basedb.clients.migrate.Migrater.verifySchemaVersion(Migrater.java:531)/ query checking schema version has to be changed (double quotes are necessary). Without this migration from Postgres database won't even start.
The second thing is transferring wizzzards. In our Base1 database those with /formatType=reportermap/, have column and row numbers in /mapping/ property proceeded by /_r_x /and/ _r_y/ respectively, not by /numCol/ and /numRow/ as WizzzardTransfer class expects. That causes the ReporterMapImporter plugin configuration to fail. I don't know if the mapping format has changed, but if the old one is still in use, the migration could support it. And the last thing concerning only older Postgres server versions (< 8.0 according to http://archives.postgresql.org/pgsql-jdbc/2005-11/msg00127.php) is that they don't support JDBC's PreparedStatement.getParameterMetaData method. Luckily this method is not used very often and only minor changes in code (Transfer.java, SampleTissueTransfer.java, UserTransfer.java) were made to make migration run without this method. Users with 8.* Postgres versions shouldn't have this problem. All the best, Pawel Sztromwasser ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
