You can use MS SQL's Scripting tool to produce the table structure, but MS
SQL's scripts need to be massaged a bit before you can use them with MySQL
to create the database.
The data is another story. MS discontinued the 'DUMP' command after SQL
Server 6.5 (it is in 7.0 for backward compatability), but I have never been
happy with the results. There are other approaches you can take (export to
CSV file, etc.), but again, the results leave something to be desired.
The only way I have been able to get the data from MS to MySQL is via
Access, using the 'Link Tables' option.
If you have enough time and programming talent, you could write an app to do
the job, but I know of none.
G. Jensen
----- Original Message -----
From: "Chris Harshman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2001 10:22 AM
Subject: Re: Can you convert a MS Sql database to MySQL?
>
> Can't MS SQL export to an "SQL Script?" I imagine it would be a simple
> matter of cat'ing said script and piping it into the MySQL CLI client.
> (Are you on a UNIX box?)
>
>
> On Fri, 13 Apr 2001, AJ wrote:
>
> >
> > Does anyone know any good source of info for the conversion of MS Sql
> > databases to MySql? Perhaps a prog that does this? Thanks for any
> > information in advance,
> >
> > AJ Workman
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
