Thread: migration?

migration?

From
guilherme@bis.com.br
Date:
Hi,
I have to migrate my data base from MS SQL Server to MySQl or to PostGreSQL.
At first, I tried begun migrating to MYSQL, but there were so many bugs that
I started to thing, why not PGSQL? So, i'd like to know wich one will give me
less problems.

I'll be waiting for reply.
Thanks

Guilherme

RE: migration?

From
Carlos Felipe Zirbes
Date:
You seem to be very skeptical about open source databases. Well, maybe you
shouldn't.  :^)

Some people use MySQL and think it is a good database because it fulfill
their needs. Then, some people use Pgsql and think it is a good database,
also because it fulfill their needs. What you've got to do is to find out
what features you'll be needing and then choose the DB accordingly.

My guess is that you'll end up choosing Pgsql, since you're coming from SQL
Server and probably don't want to loose functionality. But, then again,
maybe you don't need that much functionality and will do better by using
MySQL.

Carlos Felipe Zirbes
DBServer Assessoria em Sistemas de Informação
E-mail: carlosz@dbserver.com.br
Fone: (51) 378-9056
Fax: (51) 342-4838





-----Original Message-----
From: guilherme@bis.com.br [mailto:guilherme@bis.com.br]
Sent: sexta-feira, 6 de abril de 2001 14:10
To: pgsql-general@postgresql.org
Subject: [GENERAL] migration?


Hi,
I have to migrate my data base from MS SQL Server to MySQl or to PostGreSQL.
At first, I tried begun migrating to MYSQL, but there were so many bugs that
I started to thing, why not PGSQL? So, i'd like to know wich one will give
me
less problems.

I'll be waiting for reply.
Thanks

Guilherme

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: migration?

From
"Zhiqiang.Shi"
Date:
I guess you will finally choose PGSQL if you really want to use open source,
there is an comparison at
http://www.phpbuilder.com/columns/tim20000705.php3?page=1

hope this will help.

----- Original Message -----
From: <guilherme@bis.com.br>
To: <pgsql-general@postgresql.org>
Sent: Friday, April 06, 2001 1:09 PM
Subject: [GENERAL] migration?


> Hi,
> I have to migrate my data base from MS SQL Server to MySQl or to
PostGreSQL.
> At first, I tried begun migrating to MYSQL, but there were so many bugs
that
> I started to thing, why not PGSQL? So, i'd like to know wich one will give
me
> less problems.
>
> I'll be waiting for reply.
> Thanks
>
> Guilherme
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)