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]
