Visual Studio Team System 2008 Database Edition GDR September CTP


The Visual Studio Team System 2008 Database Edition GDR September CTP is now available for download. This is the last CTP, we started our final descend, we will publish a public RC (release candidate) when it is ready, followed by the RTM release. The upcoming RC (release candidate) will be a "go-live" release. The two remaining areas the team is currently working on is performance and bugs, we are done with all work items.

What is new in the September CTP (#17):

  • The SQL Server 2008 support has been completed, all DDL 2008 statements are now supported.
    • The SQL Server 2008 T-SQL parser now understands all new 2008 syntax and statements.
  • Schema Compare and Import Schema supports translation between SQL Server versions. For example can now compare a SQL Server 2005 database project with a SQL 2008 database.
    • The target version defines the object set used to compare. For example when comparing a 2005 source database against a 2000 target database, only the objects applicable to the SQL Server 2000 version are compared, SQL Server 2005 specific objects types like queues, message types etc are ignored as part of the comparison.
  • The Schema Compare "Ignore" options are now also available in Deployment (part of the .sqldeploymemt file)
  • Deployment and Schema Compare "Write Updates" now support wrapping the DDL statements in a transaction.
  • Permissions are now supported and stored/modeled inside the .sqlpermissions file.
  • The sequential data bound generator has been moved in to the product
  • SQLCMD variables can be mapped to MSBuild properties inside the .dbproj file.
  • Methods and properties (class and static) exposed by SQL-CLR user defined data types are now being resolved.
  • The public API for feature extensions: database generators, data distributions, static code analysis rules, refactoring types, refactoring targets and test conditions have been finalized.

Pre-requisites:

This CTP requires that the following components are installed:

Download location:

You can download the September CTP (#17) from the following location:

If you have a previous version of the GDR installed, you will have to first uninstall these before installing the latest CTP bits.

Other notes:

  • Make sure to uninstall previous CTP versions of the Visual Studio Team System 2008 Database Edition GDR.
    • You can use the following command line command to uninstall previous versions of the GDR
    • msiexec /X {DDF197C6-4507-3A19-A4B5-0E17CC931370}

  • CTP17 does upgrade projects from Visual Studio Team Edition for Database Professionals and Visual Studio 2008 Team System Database Edition (incl. SP1).
  • CTP17 will not upgrade previous GDR CTP projects.
  • The Visual Studio Team System 2008 Database Edition Power Tools do not work in combination with the GDR release.
    • We will update the Power Tools to support the GDR after the GDR has been released.
  • Feature extensions: database generators, data distributions, static code analysis rules, refactoring types, refactoring targets and test conditions that you developed for previous releases or versions of the GDR will need to be recompiled, to reflect API and namespace changes in the public API.

We are looking forward to your feedback which you can post to our MSDN forum and please file bugs and improvement requests using our Microsoft Connect site.

Thanks,
-GertD

Comments (15)

  1. The Visual Studio 2008 Team Edition for Database Developers (aka DBPro) GDR (General Development Release)…

  2. Toujours dans les prémices de ce que sera la version prochaine de Visual Studio, intéressons nous plus

  3. We’ve just released a new CTP for the GDR update of the Team System Database Edition product that adds

  4. Got Team? says:

    Gert's got all the details on his blog . To me, the biggest point to latch on to is this: This is

  5. つい先月、August CTP のリリースを紹介したばかりですが、先日 Database Edition 2008 GDR の September CTP がリリースされました。 なんともハイペースと思っていらっしゃるかも知れませんが、SQL

  6. Добавлена поддержка MS SQL 2008 The SQL Server 2008 support has been completed, all DDL 2008 statements

  7. На сайте загрузки Майкрософт появилась очередная предварительная версия Microsoft® Visual Studio…

  8. Brian Harry on Shining the Light on Rosario and More Links on the VS/VSTS/TFS 2010 & .NET Framework…

  9. Visual Studio Team System 2008 Database Edition GDR September CTP

  10. HosamKamel says:

    Hello ,

    I’ve installed this CTP i never installed GDR before , I’m facing the following error with the current Microsoft Visual studio 2008 database project

    Error 2 The syntax check failed ‘Unexpected end of file occurred.’ in the batch near ” . 0 0 Database

    could you please help in this issue?

  11. The Visual Studio Team System 2008 Database Edition GDR September CTP is now available for download.

  12. Data Dude says:

    During my session at PDC I announce the immediate availability of the Release Candidate (RC) of Visual

  13. KoenWillemse says:

    Hello Gert,

    looks real great this! Is there also somewhere an example on how you can map MSBuild properties to SQLCMD variables?

  14. Sam Harry says:

    Is there any way to debug why an extension isn’t appearing?  I have created a test condition and can’t see why it won’t appear in VS when I create unit tests.