For migrating my old database from MySQL to SQL Server, which edition is suitable, 2005 or 2008 R2? Some developers suggested me to stick to the old version.
Suggest Pros and Cons. I will be using with my .NET standalone Windows app.
+3
A:
I would go with 2008 R2, if for no other reason then the fact that mainstream support for 2005 will end on 04/12/2011.
Joe Stefanelli
2010-10-29 15:39:00
+3
A:
I would recommend 2008 R2 over the 2005 Express Edition for the fact that the database size limit on 2005 Express is 4 GB, when 2008 bumped that up to 10 GB. RAM is still limited to a maximum of 1 GB.
There's also the addition of the hierarchyid, besides the fact of impending loss of support for 2005...
OMG Ponies
2010-10-29 15:39:05
Why "over the 2005 Express"?
vgv8
2010-10-29 15:44:52
+1 for bringing up the increased gb limit. I didn't know they bumped it up in 2008. That makes me so happy that I may just track down a couple other comments of yours and upvote them as well.
wllmsaccnt
2010-10-29 15:45:07
@vgv8: the rest of the sentence (answer, really) explains why.
OMG Ponies
2010-10-29 15:47:03
Is there any limitation on RAM? Is it still 2GB?
RPK
2010-10-29 16:00:00
@RPK: Both [2005](http://msdn.microsoft.com/en-us/library/ms345154%28SQL.90%29.aspx) and 2008 are limited to a max of 1 GB
OMG Ponies
2010-10-29 16:06:29
@OMG: Than not of any use. My customer's PC has 2GB RAM.
RPK
2010-10-29 17:29:43
@RPK: That's about what you can expect from the various Express versions - Oracle, DB2, etc. PostgreSQL might be worth considering.
OMG Ponies
2010-10-29 17:38:35
A:
Microsoft has announced that mainstream support for SQL Server 2005 will end 4/12/2001. http://support.microsoft.com/lifecycle
I would use the newer version as it has a longer life span and also has some cool features like the compressed storage format and compressed backups. If you are thinking of using the free Express version 2008 R2 allows databases of up to 10GB, while the older version limits you to 4GB.
J Edward Ellis
2010-10-29 15:49:00
That is 1 GB completely dedicated to SQL Server. You will need the rest for Windows and your other applications. On a system with a total of 2 GB RAM it is actually quite a good fit.
J Edward Ellis
2010-10-31 05:22:22