SQL Server 2008 R2 Express version with advanced services and Developer Edition

  • I've been working with SQL Server 2008 R2 Express version with advanced services and SQL Server Business Intelligence Studio to create and implement reporting in reporting services. Can you tell me are other services available such as SSAS and SSIS in the express version with advanced services? I believe they are not.

    Can you also tell me if the SQL Server 2008 R2 Developer Edition has SSRS, SSAS, SSIS and SQL Server Business Intelligence Studio as part of the package.

    Thank you!

  • The DEVELOPER edition contains all the features that the ENTERPRISE edition contains.

    http://msdn.microsoft.com/en-us/library/cc645993.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Pay special attention to the license though as you can't deploy it for use in a production environment.

  • Thank you all your replies. Here's my final question: Is SQL Server Business Intelligence Development Studio a part of the Developer edition?

  • I believe Ron has already answered that question.

    Yes, it does.

  • Yes. It has everything that the Enterprise Edition has, just that its license is restricted to development/testing.

    It has one drawback to be aware of when developing solutions. If your target environment is Standard Edition, be sure you don't use any Enterprise Edition only features.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply