[_] Advice on migrating from Mysql to Pgsql
Derek Almond
home at derekalmond.com
Thu Jan 10 14:58:36 GMT 2008
>> >> An now in true underscore style , the sanctimonious "of course that >> doesn't effect me" bit .... >> >> For what its worth i use Perl Catalyst with Class::DBIx which is >> database neutral because it abstracts all the SQL and gives you yummy >> objects to do all the queries and all the smugness you can eat. But surely that does affect you if you want to port your DB from one format to another - its not about where your code can reach, its about where your data is right now. I suppose you could use two db objects, one for each db type and copy the data across that's way - might work for simple cases... you'd still need to sort out the schemas though, so its not really a win since apart from the quoting differences you can import a SQL dump from mysql to postgres if its only simple data. Rick, as I recall Colin did this for sift when they moved from mysql to postgres, do you recall him pulling his hair out lots? D