May 20, 2011 at 1:57 pm
I have developed my DB in MSSQL 2008 R2 developer edition (I think developer is the MSSQL enterprise edition)
My database is compatible level 10 ( ie MSSQL 2008 R2 db)
I go to my hoster to select the database type for setup and one of the options to select is:
MSSQL 2008 R2 Web?
Questions:
1) What is it?
2) Is my Db compatible ?
3) Do I need to convert it?
Please advise??
May 20, 2011 at 2:04 pm
It is a version of SQL Server i.e. Devleoper, Standard etc. See below sites for information
May 20, 2011 at 2:45 pm
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx
From this link I assume I can take a DB from developer edition and isntall it into a web edition?
May 20, 2011 at 2:54 pm
Take a look at the link. It's a list of the different editions and a comparison of them. For the most part a database coded for one edition will be compatible with another edition. The exception is if you use a feature like page compression that isn't available in the edition you're going to. You can look at the sys.dm_db_persisted_sku_features DMV to determine whether or not your server uses any of those features.
May 20, 2011 at 2:58 pm
cfradenburg is correct. You can install your database if you script it, but if you have used any features that are limited by edition, you will not be able to use them. IF you have used something that is limited to EE or DC editions, you may end up being unable to restore or attach the database.
May 20, 2011 at 3:05 pm
Then I assume that the developer edition crosses many versions, and its just depends on what features I have used in the Dev edition as to if it will work in other editions.
What are 2008 R2 Web specific feature differences then ?
A very important question, CAN I take a .bak file from a MSSQL 2008 R2 Web edition to a MSSQL 2008 R2 developer edition (Database compatibility of 10 for each) ?
May 20, 2011 at 9:23 pm
Look at the links above for a comparison of editions and what you can do with each.
As long as your database is the same level, meaning same server version and sometimes service pack, you can backup restore from one to the other.
The Dev edition has all features enabled, just as Enterprise.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply