Visual Studio Team System 2008 Database Edition GDR September CTP

Visual Studio Team System 2008 Database Edition GDR September CTP

Published On: Visual Studio Team System 2008 Database Edition GDR September CTP

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.