Gavin Clark wrote:
>
> on 6/2/00 12:02 PM, Stephen Atkins wrote:
>
> > Not sure if this belongs here but does any one know of a db convert from
> > MSSQL 7.0 to MySQL?
> >
> > Stephen Atkins
> > [EMAIL PROTECTED]
> >
> mysql has a way to export the whole database as a SQL file with all the data
> and instructions for building the whole thing from scratch. if MSSQL 7.0 has
> a similar export format you're home free. just export from mssql as SQL
> (yourdatabaseexport.sql) then drop it straight into mysql with:
> # mysql yourdatabase < yourdatabaseexport.sql
>
> Gavin
Gavin's method is the simplest method, but the slowest (especially
if it's a large db). Extract the tables into flat files, then
load them into the MySQL db. Since you have many seperate flat
files, you can employ parallelism and load X number of tables
at once. The # of parallel loads should depend on the number
of devices you are spreading the tables across, how many
controllers you use, and how many CPUs. After you load all the
tables, create the indexes in parallel also...
Sinncerely,
Ron Johnson
Database Administrator
Lockheed Martin IMS
--
+----------------------------------------------------------+
| Ron Johnson, Jr. Home: [EMAIL PROTECTED] |
| Jefferson, LA USA WWW : [EMAIL PROTECTED] |
| |
| Most overused words: feel, cool/kewl, fun, myBlah.com |
| Most underused word: think |
+----------------------------------------------------------+
