Page 1 of 1

mysql calls and mssql question

Posted: Sun Jul 15, 2007 7:09 pm
by mwalsh
I have a customer that we are building a web based app for. It has been built using mysql and php and my customer wants to sell it to folks who have either mssql or mysql.

Since the code is currently specific to mysql, is there any way to allow either without extensively rewriting the application?

Thanks!!!

Mike

Posted: Sun Jul 15, 2007 7:16 pm
by feyd
That would depend on how modular your code is currently. If you're currently using a database abstraction layer then it is relatively simple. If not, it's more challenging.

Posted: Sun Jul 15, 2007 7:37 pm
by mwalsh
It isn't terribly modular at this point. Should I assume that mysql calls won't work with mssql?

Thanks,

Mike

Posted: Sun Jul 15, 2007 7:45 pm
by feyd
Most often, only the most basic SQL will work across both.