thanks guys!
i think i may have to do a combination of both dumping into an SQL script,
and a CSV file.... the scripts MS SQL generates is for creating the table
structures, not yet the actual data. plus i'll have to edit the data types
for each of the non-primitive data types (i dont suppose you have varchar in
MySQL or PostgreSQL?). after that i'll just import the CSV file.... not as
easy as i'd hoped pero if i wanted easy, i might as well stay with M$
instead, right? hehehehe
again, thanks for the directions. :)
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------
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Orlando Andico
> Sent: Monday, August 20, 2001 2:22 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [plug] MS SQL Server Migration
>
>
> On Mon, 20 Aug 2001, Reynald I. Ngo wrote:
> ..
> > MS SQL Server can dump your data into a SQL script then run
> > it on your MySQL/PostgreSQL.
>
> That's very inefficient, causes index rebuilds.
>
> Better to export as CSV or similar space-delimited format and do a
> bulk-load (LOAD DATA INFILE for MySQL, Oracle has a similar scheme, dunno
> about Pg).
>
>
> --
> Orlando Andico <[EMAIL PROTECTED]>
> Mosaic Communications, Inc.
>
> _
> 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]
