Page 1 of 1
migration
Posted: Tue 23 Dec 2008 09:06
by jkuiper
This is great. If a customer wants to change databases Mysql -> PostgreSQL, is there a migration to it.
Posted: Tue 23 Dec 2008 12:34
by Plash
PgDAC does not have a tool for migration from MyDAC. You should replace components manually (for example, open *.pas and *.dfm files in a text editor, and use the Replace All command).
Re: migration
Posted: Tue 23 Dec 2008 14:25
by snorkel
jkuiper wrote:This is great. If a customer wants to change databases Mysql -> PostgreSQL, is there a migration to it.
It's pretty easy to move data from MySQL to PGSQL.
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)
Later,
Snorkel