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

Groups > comp.databases.postgresql > #704

Re: migrate from mysql to pgsql

Show all headers | View raw

Magnus Warker <magnux@mailinator.com> writes:
> There are situations where I want to decide for myself what to do, e. g. if
> there is a datatype in MySQL that's not present in PgSql.

That's covered in the load command, and in the --cast command line switch.

> I see your point, but I think it also depends on the migration strategy. I
> had to do a lot of manual work, but I prefer to do it carefully step by step
> to having things automated too much.

In my opinion, the more complex the migration is, the more you want to
automate it completely, with test cases that you can run nigthly and
from which you can analyze problems the next day.

Do the full migration once a day for a couple months while you fix the
application so that you're confident no surprise will jump at you on
D-day: you've been doing that before.

-- 
Dimitri Fontaine
PostgreSQL DBA, Architecte

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

Thread

migrate from mysql to pgsql Magnus Warker <magnux@mailinator.com> - 2015-10-30 20:00 +0100
  Re: migrate from mysql to pgsql Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2015-10-30 20:26 +0100
    Re: migrate from mysql to pgsql Magnus Warker <magnux@mailinator.com> - 2015-11-14 04:25 +0100
      Re: migrate from mysql to pgsql Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2015-11-14 20:32 +0100
        Re: migrate from mysql to pgsql Magnus Warker <magnux@mailinator.com> - 2015-11-18 17:58 +0100
  Re: migrate from mysql to pgsql Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2015-11-01 22:09 +0100
  Re: migrate from mysql to pgsql Luuk <luuk@invalid.lan> - 2015-11-02 09:18 +0100
  Re: migrate from mysql to pgsql Magnus Warker <magnux@mailinator.com> - 2016-01-06 06:43 +0100
    Re: migrate from mysql to pgsql Robert Klemme <shortcutter@googlemail.com> - 2016-01-06 13:08 +0100
      Re: migrate from mysql to pgsql Magnus Warker <magnux@mailinator.com> - 2016-01-06 13:35 +0100
    Re: migrate from mysql to pgsql Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2016-01-06 21:31 +0100
      Re: migrate from mysql to pgsql Magnus Warker <magnux@mailinator.com> - 2016-01-31 06:21 +0100
        Re: migrate from mysql to pgsql Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2016-01-31 22:19 +0100

csiph-web