[GRLUG] ms sql -> mysql

[Jeff Cook]

If it were me, since you need create a brand new app and just use the data
they have. I would recreate there database in mysql using the MySql gui
tools. Then export theirs in csv and import using phpmyadmin or mysql gui
tools. One thing I keep an eye out for in MSsql Proc (Stored Procedures)
you will need to recreate these. other then that it should be like another
mysql/php app. Do not get caught up in converting mssql > mysql It not bad
deal, I do it all the time. :)

If you want you could use there database for developing the app and
convert the last thing

check out this link on how to connect to mssql on linux
http://ubuntuforums.org/showthread.php?p=6823026

If it stresses you out can buy a tool that will do it for you. One i found
on Internet
http://www.winsite.com/Business/Database-Management/MS-SQL-to-Mysql-Converter/
< I have not try it

Jeff Cook
-----------------
"people are using toy operating systems, which is what we're all sitting
in front of, I mean, Windows is a toy."  - Steve Gibson




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