Обсуждение: I have a question?
Dear Firends:
Now I want to migrate all data from MySQL to PostGRESQL.There are hands of tables in MySQL.I want to to know if there are some tools to help me to do that.Also I want to know the key point to finish that process and how much time it may take! Very Thanks!
cruise dong
你 知 道 2006 年 最 火 爆 的 电 子 邮 箱 吗 ？
多 达 1.1 亿 中 国 人 选 择 网 易 2000 兆 免 费 邮 箱 ， 抢 注 再 得 280 兆 超 大 网 盘
Now I want to migrate all data from MySQL to PostGRESQL.There are hands of tables in MySQL.I want to to know if there are some tools to help me to do that.Also I want to know the key point to finish that process and how much time it may take! Very Thanks!
cruise dong
你 知 道 2006 年 最 火 爆 的 电 子 邮 箱 吗 ？
多 达 1.1 亿 中 国 人 选 择 网 易 2000 兆 免 费 邮 箱 ， 抢 注 再 得 280 兆 超 大 网 盘
Hmm,
Not sure about an easy way to do this using Postgres's built-in tools - try www.sqlmanager.net - they have lots of export tools to export data from one system to another, and they do 30-day trials of most of them.
Andy
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of cruise0078
Sent: Friday, 07 April, 2006 5:35 am
To: pgsql-admin@postgresql.org
Subject: [ADMIN] I have a question?
Now I want to migrate all data from MySQL to PostGRESQL.There are hands of tables in MySQL.I want to to know if there are some tools to help me to do that.Also I want to know the key point to finish that process and how much time it may take! Very Thanks!
cruise dong
你 知 道 2006 年 最 火 爆 的 电 子 邮 箱 吗 ？
多 达 1.1 亿 中 国 人 选 择 网 易 2000 兆 免 费 邮 箱 ， 抢 注 再 得 280 兆 超 大 网 盘 !DSPAM:14,4436b1ad33691062811647!
cruise0078 wrote: > Dear Firends: > Now I want to migrate all data from MySQL to PostGRESQL.There are > hands of tables in MySQL.I want to to know if there are some tools to > help me to do that.Also I want to know the key point to finish that > process and how much time it may take! Very Thanks! > cruise dong > > > > > > > 你 知 道 2006 年 最 火 爆 的 电子 邮 箱 吗 ？ > 多 达 1.1 亿 中 国人 选 择 网 易 2000 兆 免 费 邮 箱 ， 抢 注 再 得 > 280 兆 超 大 网 盘 <http://www.126.com/help/126fab.htm> You can use phpMyAdmin's functionality to export all the data to standard SQL files (.sql) and then use these to put the data back into PostgreSQL. Regards, gamehack
mySQL uses a weird CREATE TABLE syntax (with added options like table engine type etc) that Postgres errors on - so some manual editing of the SQL dump will be necessary. An export tool is probably the best way to go, that'll read data from one ODBC driver and write it to another. www.sqlmanager.net has some useful tools like that, and for a one-off job most of them come as 30-day trials. Andy -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql. org] On Behalf Of Milen Dzhumerov Sent: Sunday, 09 April, 2006 10:37 pm To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] I have a question? cruise0078 wrote: > Dear Firends: > Now I want to migrate all data from MySQL to PostGRESQL.There are > hands of tables in MySQL.I want to to know if there are some tools to > help me to do that.Also I want to know the key point to finish that > process and how much time it may take! Very Thanks! > cruise dong > > > > > > > 你 知 道 2006 年 最 火 爆 的 电子 邮 箱 吗 ？ > 多 达 1.1 亿 中 国人 选 择 网 易 2000 兆 免 费 邮 箱 ， 抢 注 再 得 > 280 兆 超 大 网 盘 <http://www.126.com/help/126fab.htm> You can use phpMyAdmin's functionality to export all the data to standard SQL files (.sql) and then use these to put the data back into PostgreSQL. Regards, gamehack ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster !DSPAM:14,44397f0d33691259350361!