SQL 2000 to MySQL

[mattboston-Re5JQEeQqe8AvxtiuMwx3w at public.gmane.org (Matt Shields)]

How knowledgeable in databases & SQL are you?  Quick and dirty would
be to export from SQL Server and try an import to see if it fails. It
probably will because there are some differences in T-SQL (MS) and
MySQL's query language, so you might end up fixing some of the create
table's and inserts.  Also depending what version of mysql you're
going to (<5) it doesn't support procedures and a few other things.
When I've done this in the past, I've done it on a table by table
basis to make sure each table imported properly and indexes were
created properly.

-matt

On 01-Aug-2007 10:52:41 EDT, Michael Webb <mwebb-Dt0PXscwUuU at public.gmane.org> wrote:
>
> Hello everyone- hoping someone can help me on this one.  I have never used
> Mysql so I apologize in advance for the ignorance.
>
> I have a sql 2000 dB or rather specific tables, I need to get these tables
> and the structures to someone who just has Mysql, is there a format or a
> way to get them this information easily?  I gave them a csv file but I
> guess that doesn't have enough information in it for them.
>
> Thanks,
> Michael
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> _______________________________________________
> Discuss mailing list
> Discuss-mNDKBlG2WHs at public.gmane.org
> http://lists.blu.org/mailman/listinfo/discuss
>

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.