Обсуждение: MySQL-to-PostgreSQL

Поиск
Список
Период
Сортировка

MySQL-to-PostgreSQL

От
Yevgeny Ioffe
Дата:
Hello,

I am working on transferring MySQL dumps to
PostgreSQL. I have tried the scripts I found in
relevant section of PostgreSQL documentation website,
but they all give me various parsing errors.  What am
I to do?

Thanks!

Re: MySQL-to-PostgreSQL

От
Bruce Momjian
Дата:
Have you tried src/contrib/mysql scripts?

---------------------------------------------------------------------------

Yevgeny Ioffe wrote:
> Hello,
>
> I am working on transferring MySQL dumps to
> PostgreSQL. I have tried the scripts I found in
> relevant section of PostgreSQL documentation website,
> but they all give me various parsing errors.  What am
> I to do?
>
> Thanks!
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: MySQL-to-PostgreSQL

От
Martin Marques
Дата:
This scripts don't do the job completly, but give you a boost. I normally pass
my MySQL dumps throught these scripts and then open them with my editor and
do the changes that were missing.

You will always have to make changes in things like MySQLs inconsistencys
(dates that don't exist, an so on).

El Jue 25 Sep 2003 19:49, Bruce Momjian escribió:
> Have you tried src/contrib/mysql scripts?
>
> ---------------------------------------------------------------------------
>
> Yevgeny Ioffe wrote:
> > Hello,
> >
> > I am working on transferring MySQL dumps to
> > PostgreSQL. I have tried the scripts I found in
> > relevant section of PostgreSQL documentation website,
> > but they all give me various parsing errors.  What am
> > I to do?
> >
> > Thanks!
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> >                http://www.postgresql.org/docs/faqs/FAQ.html

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

Re: MySQL-to-PostgreSQL

От
"Marek Lewczuk"
Дата:
I suggest you to do it manualy.... I'm mean the structure only... Then
you can make mysqldump only with inserts... Belive me that this is much
faster....

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Yevgeny Ioffe
> Sent: Thursday, September 25, 2003 9:20 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] MySQL-to-PostgreSQL
>
>
> Hello,
>
> I am working on transferring MySQL dumps to
> PostgreSQL. I have tried the scripts I found in
> relevant section of PostgreSQL documentation website,
> but they all give me various parsing errors.  What am
> I to do?
>
> Thanks!
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
               http://www.postgresql.org/docs/faqs/FAQ.html