dbTalk Databases Forums  

mysql migration

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss mysql migration in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bryan Irvine
 
Posts: n/a

Default mysql migration - 04-19-2004 , 05:50 PM






I have an older mysql implementation that is going to be upgraded soon.
Rather than upgrade it to another version of mysql I was thinking of
upgrading it to postgres. Anyone done this? What's the easiest way?

--Bryan


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match


Reply With Quote
  #2  
Old   
joseph speigle
 
Posts: n/a

Default Re: mysql migration - 04-19-2004 , 08:43 PM






bryan,
there are scripts which will do the conversion of your dump file for you in the contrib/mysql directory of the source.
That will change the structure and syntax of the create statements/data types to postgresql ones.

joe

On Mon, Apr 19, 2004 at 03:50:30PM -0700, Bryan Irvine wrote:
Quote:
I have an older mysql implementation that is going to be upgraded soon.
Rather than upgrade it to another version of mysql I was thinking of
upgrading it to postgres. Anyone done this? What's the easiest way?

--Bryan


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.