Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
3 posts • Page 1 of 1
It's pretty easy to move data from MySQL to PGSQL.jkuiper wrote:This is great. If a customer wants to change databases Mysql -> PostgreSQL, is there a migration to it.
Basically you take the create table statements from MySQL and modify them so they work on PGSQL, most stuff is exactly the same, then use a admin tool that has a good import export tool (Lightning Admin) for example, then
simply import the data into your new PostgreSQL tables.
Most MySQL data out there does not have Stored Procs or views, so it's pretty easy. I have even migrated complex MS SQL server and Firebird databases to PGSL this way.
It's not difficult at all and no special migration tool is needed (other than a good admin tool that can import and export data to tables)