Which version of sql is best to use and easiest to delploy

**puterwoman** · 12-19-2011, 09:05 AM

Greetings,

We currently host our site on a discountasp.net server using VWD express and MS Access as the back-end database. We have a need to upgrade our site and before I plunge into something and get in over my head I'm trying to decide which is the best SQL database to use.

I have VS 2010 Professional edition which came with MS SQL10.SQLExpress now my dilemma is that in the next year or so, we will finally go mobile and I understand that the compact edition is good for the mobile devices so I also have SQL Server Compact 3.5 SP2 at my disposal.

Our site is small but important to our customer base, for instance we only have approximately 85 registered users (customer base). I was hoping I could use the compact edition? Do I have to have separate domains for internet vs mobile platforms?

I want to use the canned membership/role providers in VS 2010 offered via sqlexpress

It has also been recommended that I test my current site in Windows 2008/IIS7 which was answered directly by discountasp.net via a support ticket

**Tasslehoff** · 12-22-2011, 04:15 PM

We support SQL Server Compact Edition, however, for growth, you might want to consider using SQL Server 2008 R2.

12-19-2011, 09:05 AM	#1
puterwoman Join Date: Dec 2011 Posts: 1	Which version of sql is best to use and easiest to delploy Greetings, We currently host our site on a discountasp.net server using VWD express and MS Access as the back-end database. We have a need to upgrade our site and before I plunge into something and get in over my head I'm trying to decide which is the best SQL database to use. I have VS 2010 Professional edition which came with MS SQL10.SQLExpress now my dilemma is that in the next year or so, we will finally go mobile and I understand that the compact edition is good for the mobile devices so I also have SQL Server Compact 3.5 SP2 at my disposal. Our site is small but important to our customer base, for instance we only have approximately 85 registered users (customer base). I was hoping I could use the compact edition? Do I have to have separate domains for internet vs mobile platforms? I want to use the canned membership/role providers in VS 2010 offered via sqlexpress It has also been recommended that I test my current site in Windows 2008/IIS7 which was answered directly by discountasp.net via a support ticket

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

12-22-2011, 04:15 PM	#2
Tasslehoff DiscountASP.NET Staff Join Date: Dec 2010 Posts: 661	We support SQL Server Compact Edition, however, for growth, you might want to consider using SQL Server 2008 R2.