On Mon, Aug 20, 2001 at 11:23:14AM +0800, joel realubit wrote:
> hi folks!
>
> i have a somewhat thorny question... is there any automated way to migrate
> data in a MS SQL Server database to MySQL or PostgreSQL? or do i have to
> re-encode everything by hand (aagh!)?
>
One way to do it automatically is to use DBI::ODBC or a similar
mechanism to get a perl script to dump your database into a common
format (there's a module that will output XML, that might work), and
then import that format.
You may even be lucky, MSSQL may have a mechanism for dumping the
database into a script of SQL commands that will regenerate the
database when run by any SQL parser, in that case, migration will be
perfectly trivial.
--
Rafael R. Sevilla <[EMAIL PROTECTED]> +63(2) 8177746 ext. 8311
Programmer, InterdotNet Philippines +63(917) 4458925
http://dido.engr.internet.org.ph/ OpenPGP Key ID: 0x5CDA17D8
PGP signature
