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.


.