History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: LDEV-1103
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Ernie Ghiglione
Reporter: Ernie Ghiglione
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
LAMS Development

Port LAMS db to Postgresql 8.x

Created: 23/Dec/06 01:23 AM   Updated: 03/Aug/07 01:14 PM
Component/s: General
Affects Version/s: None
Fix Version/s: 2.1

File Attachments: 1. GZip Archive mysql2pgsql-1.3.tar.gz (13 kb)


Resolution Date: 03/Aug/07 01:14 PM


 Description  « Hide


This is quite good to do the conversion of the db model: http://www.raditha.com/mysql/mysql2pgsql.php

 All   Comments   Change History   FishEye      Sort Order:
Ernie Ghiglione - 28/Apr/07 11:17 AM
Excellent script to move mysqldumps to postgres

See for more details:
http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

Change by Ernie Ghiglione - 28/Apr/07 11:17 AM
Field Original Value New Value
Attachment mysql2pgsql-1.3.tar.gz [ 10966 ]

Ernie Ghiglione - 03/Aug/07 01:14 PM
I have managed to run LAMS in postgres by using this script.

I installed LAMS in MySQL, dump the LAMS db, run this script and then import the output into Postgres 8.2.x. Changed the mysql settings in LAMS to talk to Postgres instead and bang! LAMS is working with postgres.

Also, I have found commercial scripts to do the same with Oracle (http://convert-in.com/sql2ora.htm) so potentially this would be the same case.

Thanks Hibernate!

--

Now SQL scripts for upgrades are a total different issue. I guess one would have to be a lot more careful with upgrades when not using the automatic installers we provide.

Change by Ernie Ghiglione - 03/Aug/07 01:14 PM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]

Change by Ernie Ghiglione - 03/Aug/07 01:14 PM
Status Resolved [ 5 ] Closed [ 6 ]