Freigeben über

VSTSDB 2008 GDR CTP16 is here!

  • Artikel

The team is happy to announce that we just released CTP16, of the Visual Studio Team System 2008 Database Edition GDR release. We are yet another step closer to reaching the finish line which is waiting for us at PDC in Oct of this year.

This release adds the following features:

  • VSDBCMD.EXE
    • We added independent commandline deployment and reverse engineer, which can be used on machines that do not have Visual Studio installed, in order to deploy the results of a database project build (.dbschema file), or if you need to generate a .dbschema file so you can for example compare it, this commandline tool will let you do that as well.
  • Database Project (.dbproj) Upgrades
    • CTP15 enabled upgrade of project files, but did not included updating Data Generation Plans (.DGEN files), which now be upgraded when they are opened the first time inside the DGEN designer.
  • Schema Compare
    • You can now choose the SQL Command Variables (SQLCMD) to use during a Schema Compare session by clicking the “Specify SQLCMD variables” button on the Schema Compare toolbar. This will allow you to compare projects that are using SQLCMD variables and provide the contextual information via the variable values.
    • You can now set the Schema Compare options at the session level, in addition to Tools->Options, by clicking the Settings button on the Schema Compare toolbar.
    • And you can now save your Schema Compare session and reopen it again. We also added an item template for this, name "Schema Comparison"
      image
  • Extensibility
    • We finished the namespace and assembly naming cleanup. As a result all assembly names and namespaces have been changed. This means if you have code leveraging our extensibility mechanisms you need to update the assembly references and namespaces in your code.
    • We added the ability to add your own refactoring types! So now you can create your own refactoring command and have it change all the required references inside the schema. This is above and beyond the ability to create your own refactoring targets (the sources your want to change by an refactoring type), static code analysis rules, data generators, data distributions and test conditions.
    • We now also offer public access to our TSQL parsers for SQL Server 2000, 2005 and 2008, including the script generator functionality.
  • And then there are many more enhancements in the parser, interpreter, validation, build and deploy.

Pre-requisites:

CTP16 requires the following components to be installed:

Download location:

You can download CTP16 from the following location:

NOTE: If you have a previous version of the GDR installed, you will have to first uninstall this and then install the latest CTP16 bits.

To set the expectations we are not 100% done with SQL Server 2008 support, the parser was just code complete after we were done with this release and this work is now being consumed by the interpreter, script generator, validation and build and deployment components. There will be a public release candidate once we are code complete, so one more release between now and RTM.

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

  • Anonymous
    August 20, 2008
    PingBack from http://hubsfunnywallpaper.cn/?p=1581

  • Anonymous
    August 20, 2008
    Cool Stuff!  Gert just announced on his blog that CTP 16 of the Visual Studio Team System 2008 Database...

  • Anonymous
    August 20, 2008
    Cool Stuff! Gert just announced on his blog that CTP 16 of the Visual Studio Team System 2008 Database...

  • Anonymous
    August 20, 2008
    Bonjour à toutes et à tous La nouvelle CTP de Visual studio team database 2008 GDR vient d'arriver. Que

  • Anonymous
    August 21, 2008
    The comment has been removed

  • Anonymous
    August 21, 2008
    The comment has been removed

  • Anonymous
    August 21, 2008
    Any word if the performance issue with Schema comparisons is going to be addressed before release (visual studio feedback id 351623)? Cheers

  • Anonymous
    August 22, 2008
    The comment has been removed

  • Anonymous
    August 29, 2008
    The comment has been removed

  • Anonymous
    September 06, 2008
    I’m a big fan of Visual Studio Team System Database Edition and use its integrated features in my projects

  • Anonymous
    September 19, 2008
    SQL Server 2008 Database Projects

  • Anonymous
    November 13, 2008
    I'm sitting around tonight trying to reverse engineer a database with Database Professional 2008 and

  • Anonymous
    November 13, 2008
    I'm sitting around tonight trying to reverse engineer a database with Database Professional 2008 and I get this unexpected error. (they're all unexpected, aren't they)---------------------------Microsoft Visual Studio---------------------------Could not