|
Joined: Jan 2008
Posts: 13
stranger
|
stranger
Joined: Jan 2008
Posts: 13 |
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?
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
I believe that the only *officially supported* database is MySQL (which is cross platform)
|
|
|
|
Joined: Jan 2008
Posts: 13
stranger
|
stranger
Joined: Jan 2008
Posts: 13 |
unofficially I just need to try and see if it works on test environment....thanks!
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
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...
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
Both were here yesterday
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
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? 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?
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Both were here yesterday Score...
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
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.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
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..
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
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. management wants to use the sql software they purchased SQL Server 2005 Express EditionFree to download, free to redistribute, free to embed, and easy for new developers to use immediately, a simple but powerful development environment for building data-driven applications. Easily manage your database with SQL Server 2005 Management Studio Express. Be warned though that you can not publish to other database models with this version. .
|
|
|
|
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
|
Pooh-Bah
Joined: Jul 2006
Posts: 2,143 |
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....
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
not built in, but it's a 1 liner to enable it in php.ini.
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
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.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
Just curious if any resolution to this topic has happened. 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.
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
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.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
0 members (),
1,063
guests, and
171
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|