Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Linux Links | Bling | About BLU

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SQL 2000 to MySQL



Here's something worth read:

http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

-matt


On 8/1/07, Matt Shields <mattboston-Re5JQEeQqe8AvxtiuMwx3w at public.gmane.org> wrote:
> 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.







BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org