The Underscore Archives

On Thu, 2008-01-10 at 11:58 +0000, Tim Perrett wrote:
> Morning [_]
> 
> I am looking to migrate a few databases from MySQL to PostGre and  
> wondered if anyone on the list had any experience in doing this and  
> the gottcha's involved? After some googling there seem to be mixed  
> reports on how easy (or not as the case may be) this is to do?

AFAIK there is nothing that can automate this that is close to
production grade , although dbconvert.com looks interesting.

Off the top of my head - dates will be an issue , relational tables
will probably be different , users and permissions will need to be
redone, ENUM and SET and BLOB's will need conversion and any stored
procedures will need re-writing.

you could make a wish and hope the sql fairy answers it .
http://sqlfairy.sourceforge.net/ 

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.

Toodle-pip
Amias
-- 
 Freelance programming , consultancy and hardware builds
blog.amias.org.uk * www.amias.org.uk * www.ecotalk.org.uk