Moving away from MS SQL Server 2008 - Open source alternatives

Izi

Izi

Izi

Soldato
Joined
9 Dec 2007
Posts
2,718
I want to move away from MS SQL Server 2008 due to licensing/cost reasons.

I have read up and most suggest PostgreSQL as a good open source option. There is of course MySQL but I here it is lacking on quite a few fronts. I have used MySQL before and not had any problems, but if I am going to invest time in to learning a platform I want to make the correct choice from the outset.

It appears that there are providers for .NET in postgreSQL/MySQL etc so I can continue to use Entity Framework and code first.

Anyone else thinking of making this move? Or already have? Any database suggestions?
 
What will the database be used for? MySQL is perfectly fine for most uses.
 
Enterprise level is all I was thinking, can't see why it MySQL wouldn't be OK for what you want.
 
Personally I'd stick with MSSQL. Yes it is massively expensive for non volume licenses , but I can't see how this comes in to it unless you're planning on running your own server?

Develop on your local machine/network using SQL2005/2008 Express and host it with a company who include MSSQL as part of the package?
 
Spunkey said:
Personally I'd stick with MSSQL. Can't see how costing comes in to it unless you're planning on running your own server?

Develop on your local machine/network using SQL2005/2008 Express and host it with a company who include MSSQL as part of the package?
Click to expand...

I have 2 servers, cant use express its limited to 1gb ram. Currently use 16GB ram...
 
JonRohan said:
Do you need support on the database?
Click to expand...

By support, how do you mean?

I don't currently use support from MS... so not sure this would change with an open source alternative. All the help anyone needs is on Stackoverflow these days! :)
 
Izi said:
By support, how do you mean?

I don't currently use support from MS... so not sure this would change with an open source alternative. All the help anyone needs is on Stackoverflow these days! :)
Click to expand...

Some companies require vendor support, looks as though this isn't a requirement for you. :). Either way you can get vendor support for MS SQL, MySQL (probably other DB's too) if required in the future.
 
I have (via NHibernate) and it was fine. I can only surmise that it is personal preference but I prefer the syntax in Postgres and that it is an object relational DB, not just a relational DB. :)
 
Jakeee said:
PHP and MySQL is great for what your after, and how can you say its expensive when it comes free with most host sites ?
Click to expand...

ASP.NET and MSSQL aren't free at professional level, this is my preferred environment.

Thanks DJ_Jestar
 
You must log in or register to reply here.
Back
Top Bottom