jloyzaga Posted April 2, 2003 Share Posted April 2, 2003 Can I use a postgres db for osc or if I have to convert to mysql - is there a utility that I can use? Link to comment Share on other sites More sharing options...
Mark Evans Posted April 2, 2003 Share Posted April 2, 2003 Can I use a postgres db for osc or if I have to convert to mysql - is there a utility that I can use? You should be able to convert the database to postgress by exporting the mysql databse to csv. The hard part will be re-writing the queries in osC to be compatible with postgress. I am sure this has been done before, not sure how much work is involved though. Mark Evans osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops) --------------------------------------- Software is like sex: It's better when it's free. (Linus Torvalds) Link to comment Share on other sites More sharing options...
jloyzaga Posted April 2, 2003 Author Share Posted April 2, 2003 I actually want to use the existing postgress db with all its data - I guess its a case of mapping the postgress fields to mysql equivalent for use in osc? Link to comment Share on other sites More sharing options...
Mark Evans Posted April 2, 2003 Share Posted April 2, 2003 I actually want to use the existing postgress db with all its data - I guess its a case of mapping the postgress fields to mysql equivalent for use in osc? You will also need to re-write the queries in osC as I think mysql and postgress do things differently. Mark Evans osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops) --------------------------------------- Software is like sex: It's better when it's free. (Linus Torvalds) Link to comment Share on other sites More sharing options...
jloyzaga Posted April 2, 2003 Author Share Posted April 2, 2003 so maybe the smartest move is to try and import the mapped data into the osc mysql db to conform with the schema of the osc db - its a catalogue so it must be similar - that way I can use MySQL and not touch the osc. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.