just curious if UBBThreads (7.2.2) is compatible with a microsoft sql server 2005?

I just got this up and running on mysql and now management wants to use the sql software they purchased.

I assume the DB can be exported and the pathing updated in the config file to point to sql server?

I believe that the only *officially supported* database is MySQL (which is cross platform)

unofficially I just need to try and see if it works on test environment....thanks!

The best people to talk to are likely ntdoc and Sirdude; NT is a windows guru and SD is a db guru... Sadly both haven't been around as of late however...

Both were here yesterday

Well, let us know how it goes - I think it takes more than that to work with MS SQL Server, the least of which the mysql commands will need to be ported to MS SQL, eh?

Score...

Allen is correct. Out of the box is will not work.

The strings, commands, and code in general are NOT compatible with SQL 2005

Could it be ported, YES - but that would be a LOT of work and testing that currently I don't see happening as SQL 2005 is not free like MySQL is which highly restricts the customer base.

assuming your DB doesn't exceed 2Gig, there is a free version of mssql out SQL express 2005.

works fine/lasts a long time..

only prob is that we are very tied to mysql-ish SQL, so there are definitely a lot of issues involved in making that work.

it's possible though -- essentially mysql.inc.php would have an equivalend mssql.inc.php (in libs)

then the offending queries would need attention and also possible some of the field types in the actual tables..

i know i ran a converter to just convert over the mysql to mssql and that succeeded a while back, but stopped there..

:2c:

Yes there is a FREE MS SQL Express but they seem to imply they have the full version and want to use that so that's why I said it would have a very small user base. Even with the FREE MS SQL Express I don't see that being a universal option either as it only runs on Windows.




SQL Server 2005 Express Edition



Be warned though that you can not publish to other database models with this version.


.

There is also the fact that you need to make sure your php build supports mssql or that you install the proper extensions. I haven't installed php on a MS server in years. For all I know it's built in....

not built in, but it's a 1 liner to enable it in php.ini.

Just curious if any resolution to this topic has happened. Using mssql 2005 in leau of mysql. The reason is my host provider provides 100mb of sql 2005 for free and each additional 100mb is a minor amount, but I have to pay for 50mb bites of mysql at $50.00 per year. They say it is due to the increased server load.

Hello Ruben,

There really is no resolution beyond what has already been said. The product is written to support MySQL not MS SQL for obvious reasons. If the tables turn in the future and Microsoft is offering a Free database that runs on both Linux and Windows and MySQL is not as attractive for one reason or another, then things might change, but I wouldn't count on it any time soon.

I can understand your reasons, but there just is not anywhere near enough demand for MS SQL vs MySQL and that is true for just about any Internet Database project not just UBBT.

What might be better for you is to find another Host provider that is more geared towards MySQL. There are thousands of host providers out there that I'm sure have better deals than what you're currently getting.

Thanks btdoc for the reply. Yes there are lots of providers out there but my host has been the best out of three I have tried and I am not willing to change for this issue. I would rather pay a few dollars per year with what I have.