[GRLUG] ms sql -> mysql

[Topher]

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.

Awesome, thanks.

>> 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?



On Mon, 11 Apr 2011, Joseph Workman wrote:

> Can you get the data in any other form ? Can you get access to the mssql
> server? 

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.