MSSQL pricing

In answer to your questions:

• WWF runs on MS Access
• WWF runs on MS SQL Server
• WWF does not currently run on mySQL
• WWF does not currently run on any other DB platforms.
• S.Q.L. stands for Structured Query Language. It is NOT a database.
• SQL Server pricing is not expensive relative to other RDBMS platforms with its features.
• SQL Server recently finished top in numerous performance benchmarks:
  http://www.tpc.org/
  http://www.crn.com/sections/coverstory/coverstory.asp?ArticleID=40277

It great that you'd like to fine cheaper alternatives for everyone, but the fact is, WWF runs on those two database platforms ONLY. SO even if by miracle you got SQL Server to work on Linux, you still have to pay for it!!

In the end, you get what you pay for.  Plus, the forum is already free! Unless you want to write a mySQL version of the forum then you are out of luck.

Cheers,
Andrew

Let's give vdub the benefit of doubt.

Is there possibly a program that runs on Linux and emmulates MS SQL? By emmulate I mean: accept connection and querry exactly the way SQL Server does. Then we're in for the money.

I know right off the head that ASP CAN run on linux by chilisoft.

vdub, what you need to convince peepz now is to post a link to that program I said above. Then, we'll see.

cheer. and take it easy, everyone.

Being open minded goes a loooong way

There is no way to 'easily mod the forum'. Once you understand how databases work you'll realise that.

The SQL statements that Borg have used were designed for SQL Server (and Access). They are not currently compatible with mySQL. They need to be rewritten to work in mySQL.  There is NO quick 'function' to do this.

Additionally, the SQL Server version utilises stored procedures. mySQL doesn't even support stored procedures yet! So the functionality that these procedures produce woul need to be converted *back* to inline SQL statements, which would impact on performance.

Now there are some other database platforms that do support stored procedures, however SQL Server stored procedures use a language called T-SQL. Therefore this platform will have to understand T-SQL.

Off the top of my head, the only other DB that supports T-SQL is Sybase, but then they aren't completely compatible. How many hosting companies offer Sybase and how much does it cost?

So in order to do what you are trying to do, which is find another database platform that will support the WWF code, that runs on Linux, means that:

• It must support the dialect of inline SQL statements that Borg uses.
• It must support stored procedures.
• It must understand T-SQL language.
• It must be readily available on web hosting platforms
• It must be cheap.

Don't you think, that just maybe, someone here would know about it already!! Give us some credit.

By all means go ahead and waste your time, but until then, don't make statements such as:

• "I don't give it that much longer before Linux takes MS over becuse of there high pricing. " ...wrong
• "Linux already dominates Microsoft when it comes to servers they hold the biggest percentage of market share" ..wrong
• "Linux was created in 1991 that’s 12 years it has grown about 50X faster then Windows has" ...any source? or made up.
• "Not only dose Linux support ASP" ...wrong. It supports ChilliASP. They are different.
• "And by the way Linux dose support SQL Server" ...wrong. How can Linux support SQL Server when it doesn't run on it!
• "Keep in mind that Linux realy is about 60% faster" ..any source? or made up.
• "as of the last 2 years that I have been using Linux and windows at the same time the only thing that I cant do in Linux that I can in Windows is FP" .. You can't be doing much then. I have Linux installed here at home as well, and having passed my MCP on Administering Win2K Server, there is plenty that Linux cannot do.
• "I have been surfing the web for 6 hours today and I have found a lot of promising options" Then show them! Give us some hope!
• "Keep in mind there are 10 times the amount of Open Source dev. then there are win32." ..Source? or made up

I wish you the best, and hope that you find something that will benefit everyone. I hope this makes it clearer and apologise if my comments were too harsh.

Cheers,
Andrew