[GRLUG] ms sql -> mysql

L. V. Lammert lvl at omnitec.net
Mon Apr 11 18:54:57 EDT 2011

At 05:48 PM 4/11/2011, you wrote:
>On Mon, 11 Apr 2011, L. V. Lammert wrote:
>>>Anyone have any idea the best way to get it into mysql?  I see the 
>>>insert lines, and I could probably figure out the db structure and 
>>>use those in a pinch.
>>Simplest would be to load the csv into an Access database [or ask 
>>them for a .mdb of the data] and use the MySQL migration tool - 
>>point-and-click. The hardest part will be setting up a valid MySQL 
>>login & host pemissions - the MySQL Adminstrator tool is the GUI for that.
>>You could also setup SQLServer Express on you local machine (it's 
>>free) and use that as the data source for
>>It might also be possible to use phpMyAdmin, but I have not played with it.
>I love phpMyAdmin, so if I can get anything decently importable I can do that.
>I don't have MS Access, is there a "reader" like the Word reader 
>that would let me do the export you're talking about?

If you can get a .csv, phpMyAdmin does have an import process. The 
important part is getting the actual data <g>!


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

More information about the grlug mailing list