Scott Marlowe wrote:
> On Mon, Dec 15, 2008 at 11:02 PM, sai srujan <creativesrujan@gmail.com> wrote:
>> Hi....
>> This is srujan and I am beginner of postgresql 8.1 and I have
>> just stopped using mysql and i would like to use the dump (.sql file)
>> created in it. I would like transfer the databases in my sql to postgresql
>> 8.1. Please do reply. I am waiting for it.
>
> If possible, go ahead and jump right into 8.3.5. There's been quite a
> few improvements over 8.1 in it. And unlike Oracle, when a new pg
> version is released, it's considered to really be production ready
> right away, or at least within a month or so. 8.3.5 is a year old
> now, and we've been running 8.3 in production since 8.3.3 came out and
> it's fantastic.
>
> The easiest way to transfer your database over is to dump the schema
> first, and get that working on pgsql.
If you go to the PG projects site and search for "mysql" you'll find
some tools to help with this too.
http://pgfoundry.org/
--
Richard Huxton
Archonet Ltd