u not mentioned the versions of MySQL / MS SQL
Server...

this is not advisible tht u r testing in one RDBMS &
implementing on the different RDBMS.

cuz there is no Views, Triggers, Stored Procedures
in MySQL as of now which is availble on SQL
Server(anyway im lookin forward for next ver MySQL5.0
for some of these...)

backup methods are bit different in these RDBMS..

then wht else is there pure ANSI-SQL... there also u
need to change  certain methods if tht method is not
availble in the same name in MS SQL Server..

& without chaning ur source code  it's not at all
possible to change between these RDBMS..