MS SQL is too expensive. Let's FIRE the BIRD up!

10 years ago
Hi people, have been a while since I came here last time.

Well,  I really think NopCommerce is an excelent project, BUT, I'm facing the simple problem that... MSSQL server's are expensive.  Here in Brazil they charge too much just to use a SMALL MSSQL server, worse if it takes more than 10 MB.
Well, I already use Firebird in my Java Applications, daily.
How about... using Nop with Firebird? Wouldn't be nice? Would it take long? The thing is, I am no ASP.NET specialist. Where can we start from? Anybody with me?  
If I don't find a way, I'm gonna have to leave NopCommerce and choose a faster way to solve this issue. Something ready. :(

Marcio
10 years ago
I know some people talked about parking nopcommerce to mysql (search in the forum). It's a long process because of all the stored procedures that need to be rewritten, I guess it's the reason why nobody (including me) has done it yet.
10 years ago
MSSQL is a great, professional and reliable product. Without MSSQL I won't use nopCommerce. The whole administration is easier.
10 years ago
Great product - no doubt. Firebird is also a great product. Only better than MySQL because of the Commercial usage that is also for free. And the fact that MySql just started to use Triggers and stuff. Let's just add to the fact that we are talking about a free, open-source software NopCommerce. The only thing tying this software to the non-Freedom is the MSSQL. "I'll give you freedom - but only in the boundaries of this room."
10 years ago
You have sql express server, that's free
10 years ago
Internet Service Providers do not use MS SQL Server Express on their servers.
10 years ago
villela wrote:
Internet Service Providers do not use MS SQL Server Express on their servers.

Yeah, you're definitely right about that
10 years ago
I think that nopcommerce is a professional product, that will become an enterprise class product. I use a dedicated Windows Server and that doesn't cost a fortune.

One of the most important thing is, that it is built on .Net. I think that the power of .Net is best supported by MSSQL.

All the people that want to use MySQL can take one of the many PHP solutions that are out there.

The only thing I would support, would be MySQL as an option. Although I would prefer development time in new features than in another database system.
10 years ago
We've moved to Entity Framework (it will be available in the next release). So it'll be quite easy to support new databases very soon
10 years ago
Andrei,
Absolutely love the direction in which NopCommerce is going !!!!!!

On the point of MS SQL,
I second the idea of running on a VPS with MS SQL Express.   If even that is too expensive for you, either find another site to share the VPS with, splitting the cost, or re-evaluate the businesses proffitability?!?   8-)