SQL Server Developer edition

Question

I am developing an application that uses MS SQL Server 2008 off line, our server uses SQL Server 2008 Web edition version 10.0.2573.0 with SP1 and my version - 2008 R2 is incompatible. 

Upgrading the server SQL is not an option at present so I need to obtain/purchase a compatible copy of the software, so far I have been unsuccessful in finding a source.

How can I obtain a developer version that is compatible with this?

Answer 1

You can download SQL EXPRESS Edition for free.

In order to get a Dev Edition  you need to get to the local MS office and pay 50$ , now that  they will send you a disk at home.

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
MS SQL Consultants: Improves MS SQL Database Performance

Answer 2

no developer edition is not advised to use  in production , check the edition limitations below.

http://www.sqlmag.com/article/sql-server/sql-server-2008-editions99382

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 3

see here

http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx

If you are using for testing purpose you can go for developer edition.. !

---

Thanks, Rama Udaya.K "“You only live once, but if you do it right, once is enough. ― Mae West". ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

Answer 4

If only it were that easy! 

I need SQL server 2008 version 10.0.2573.0 - this is based on xp/vista whereas 2008 R2 and 2012 are based  (I believe) on windows 7.  Neither of these is compatible with the version on our server.  I can transfer from the server to my developer environment but cannot upload after working on the database.

When you try to transfer the data you receive a message telling you that the versions are incompatible, this would be fine if I can only obtain/purchase the correct version!!

Answer 5

Hi Andrew-dkl,

We received this error because the source SQL Server version (SQL Server 2008 R2) is higher than destination SQL Server version (SQL Server 2008). As Uri suggested, we can download SQL Server 2008 Express Edition and create database with it, after that, we can transfer database from SQL Server 2008 Express Edition to SQL Server 2008 Web edition version 10.0.2573.0. Additionally, we can generate database scripts (SQL Server 2008 version) with Generate and Publish Scripts Wizard on SQL Server 2008 R2, and run the scripts on SQL Server 2008.

1. In Object Explorer, expand Databases, right-click a database, point to Tasks, and then click Generate Scripts. Follow the steps in the wizard to script the database objects.
2. On the Choose Objects page, select the objects to be included in the script.
3. On the Set Scripting Options page, select the Advanced button in the Save scripts to a specific location section, change “Script for Server version” to “SQL Server 2008”. Click OK.
4. Select the location for the generated script: to a file, a Database Engine Query Editor window, or the Clipboard.
5. Follow the wizard and finish the process.
6. Copy and run the scripts on SQL Server 2008.

For more detail information, please refer to the following link:

Microsoft SQL Server 2008 Express:
http://www.microsoft.com/en-us/download/details.aspx?id=1695

How to: Generate a Script (SQL Server Management Studio):
http://msdn.microsoft.com/en-us/library/ms178078.aspx

 

---

Allen Li

TechNet Community Support