well, you can export your data from each table into a text file and make
it in a CSV (Comma delimited, string inside quotes).... so that you can
use INSERT into <table name> infile <filename> fields (etc) in mysql...
hope this helps
cheers!
adrian c. dimaunahan
http://pektus.dhs.org
On Mon, 20 Aug 2001, 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!)?
>
> tia
> joel
>
>
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.12
> GCS GIT>GCM d-(+) s: a C++(++++) UL++>++++>$ P+ L+>++++$
> E--- W+ N o-- K- w+++$>-- O- M- V- PS !PE Y+@ PGP(-) t++@ 5+@
> X-- R tv(--) b++++ DI++(++++) D+ G e++>++++ h--- r+++ y?
> -----END GEEK CODE BLOCK------
>
> _
> Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
> To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
>
> To subscribe to the Linux Newbies' List: send "subscribe" in the body to
>[EMAIL PROTECTED]
>
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]