[GRLUG] ms sql -> mysql
topher at codeventure.net
Mon Apr 11 18:48:28 EDT 2011
On Mon, 11 Apr 2011, L. V. Lammert wrote:
> At 05:06 PM 4/11/2011, you wrote:
>> A client wants me to convert their asp/mssql webapp to php/mysql. I asked
>> for an export of the data and it is most definitely NOT mysql compatable.
>> It looks a lot more like BASIC than SQL. Lots of BEGIN, END, and GO.
> Then what you have isn't an export. Ask for a "csv export with column
> headers". What you're probably looking at is ASP code.
>> 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
> 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
I love phpMyAdmin, so if I can get anything decently importable I can do
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?
On Mon, 11 Apr 2011, Joseph Workman wrote:
> Can you get the data in any other form ? Can you get access to the mssql
I can ask, but I don't have access.
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
More information about the grlug