Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #450

migration mysql to pgsql?

Show all headers | View raw

Hi,

I am planning to migrate an existing mysql (innodb) database to pgsql.

Since the database is already in production, I would like to 
successively prepare the migration by making small adaptations step by 
step so that the single downtimes can be kept short.

First of all I wanted to adapt the usage of table names, because I 
already know some names used in the mysql database that would case 
problems in pgsql. My idea is to use quotation marks for table names. 
Then, I could achieve two goals at once: a) avoid conflicts with key 
words, and b) preserve upper and lower case letters, which I use in 
mysql and which is not supported in pgsql without quotation marks. Would 
you agree that this would be a reasonable first step?

However, the adaptation of the mysql db to use qoted table names already 
is a problem, because mysql does not seem to like it.
Does someone have an idea how to deal with this?

I also noticed that there are many differences with the date and time 
column types.

Does someone have experience with migrating from mysql to pgsql?

To avoid unnecessary discussions: I already used both systems for some 
years and I know why I want to migrate.

Thank you!
Magnus

-- 
This is Unix-Land. In quiet nights, you can hear the Windows machines 
reboot.

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

migration mysql to pgsql? Magnus Warker <warker@mailinator.com> - 2013-06-05 08:46 +0200
  Re: migration mysql to pgsql? Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-06-05 10:09 +0200
    Re: migration mysql to pgsql? Magnus Warker <warker@mailinator.com> - 2013-06-05 11:43 +0200
      Re: migration mysql to pgsql? Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-06-05 11:59 +0200
        Re: migration mysql to pgsql? Magnus Warker <warker@mailinator.com> - 2013-06-05 13:06 +0200
          Re: migration mysql to pgsql? Robert Klemme <shortcutter@googlemail.com> - 2013-06-05 21:30 +0200
      Re: migration mysql to pgsql? Stefan+Usenet@Froehlich.Priv.at (Stefan Froehlich) - 2013-06-05 10:59 +0000
  Re: migration mysql to pgsql? Walter Hurry <walterhurry@lavabit.com> - 2013-06-07 21:52 +0000
    Re: migration mysql to pgsql? gargoyle60 <gargoyle60@example.invalid> - 2013-06-08 09:12 +0100
  Re: migration mysql to pgsql? johannes falcone <visphatesjava@gmail.com> - 2013-06-18 12:03 -0700

csiph-web