Someone suggest me to use a wamp for the intranet but the database is already setup with a mssql. I want to know if it's a great move to use mysql instead of mssql cause I have to migrate all data from mssql to mysql. Plus, I want to know some crappy problem that I can face during the migration.
Thanks!
I would say NO,
If it is already setup then why bother with setting up something else and dealing with data migration?
Given windows and that you already have sql server, there's nothing wrong with wasp (windows, apache, sql server, php), wisp (windows, iis, sql server, php), or wisc (windows, iis, sql server, c#). The cost to you is the same (free) in any of those scenarios.
You definitely want to stay with your existing database.
Is there some reason why it must be one or the other?
I am guessing you install WAMP because you wanted to use some php-based application for something, and the app probably requires mysql. But that doesn't mean you can't also make connections to your mssql server for accessing data that is stored there.
If you have a databased that was designed to work in mssql, and software that depends on it being their, why would you want to change that?
Second the motion of Adam Davis (see comment to the main question) - If ain't broken, why fix it? Only make it better!
MSSQL is an established enterprise dbms. I would stick with MSSQL if I were you unless it is still a SQL Server ver. 7, in which case I would upgrade to SQL Server 2005/2008.
You have hinted that you already have a sound and working system. Migrating from MSSQL to MySQL at this point, IMO, is only a matter of preference. But, hey, if this is a critical system, you should also consider the overhead of maintaining a database server!