mysql calls and mssql question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mwalsh
Forum Newbie
Posts: 2
Joined: Sun Jul 15, 2007 7:01 pm

mysql calls and mssql question

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
mwalsh
Forum Newbie
Posts: 2
Joined: Sun Jul 15, 2007 7:01 pm

Post by mwalsh »

It isn't terribly modular at this point. Should I assume that mysql calls won't work with mssql?

Thanks,

Mike
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Most often, only the most basic SQL will work across both.
Post Reply