Visual Studio Team System 2008 Database Edition GDR R2

Numerosi gli aggiornamenti della R2 di Visual Studio Team System 2008 Database Edition GDR, rilasciata nei giorni scorsi. Oltre al supporto completo a SQL Server 2008, sono state apportate le seguenti migliorie:

Schema Validation

1. Aliased external objects do not resolve
2. Permission type "SEND" is a database level permission
3. Permissions with multiple INCLUDE or EXCLUDE treatment on its columns generates invalid error
4. Common Table Expressions (CTE) names should respect the model case-sensitivity
5. Adding a permission with the object name defined as a zero length string crashes VS
6. OpenXML() generates invalid warnings or errors in SQL Server 2000 database projects
7. Sub-queries defined at the column level should be able to reference table sources of the SELECT statement
8. References to some SQL-CLR Assemblies cannot be resolved causing invalid reference errors
9. Schema bound VIEWs containing a CAST function produce invalid error
10. Validation of Database.sqlpermissions is very slow

Schema Compare

1. Visual Studio crashes when comparing a composite project (which has reference to server project) to a database on server with insufficient privileges.
2. Schema Compare option to limit comparison to only objects defined in the source does not work.
3. Schema Compare option to ignore Database Role Membership does not work.
4. Schema compare write updates to project comments out all children objects when the parent object is ignored in the comparison.

Refactoring

1. Preservation of Intent doesn’t handle creating a new object using a name that was previously rename refactored.
2. Deployment fails after a rename refactoring operation on a table that has an extended property on a column.

T-SQL Static Code Analysis

1. SR0014: Maintain compatibility between data types rule throws an exception when analyzing some schemas.

Schema Deployment

1. Some output clauses for parameters in a STORED PROCEDURE body are omitted during deployment.
2. Composite Projects that have segmented tables and constraints causes an exception during deployment.
3. Deployment silently fails when it encounters unknown or invalid syntax from the target database.
4. Deployment is dropping computed columns when updating column collations
5. Deployment is blocked when computed persisted function column on function change.
6. Deployment fails with "An item with the same key has already been added" after the project is copied to a new location on disk or when the solution configuration is changed with a specific sequence.

VSDBCMD Command Line Utility

1. VSDBCMD.exe throws exception when importing some database schemas.
2. VSDBCMD.exe throws exception when schema being deployed has multiple references to external .DBSCHEMA files.
3. VSDBCMD.exe exits incorrectly with code=0 when it encounters an unexpected exception.
4. VSDBCMD.exe depends on a registry key which prevents it from running on systems that do not have SSMS or VS installed.

Database Project System

1. SQLCMD Variables and Deployment properties files are not being persisted in the .user file when "My isolated development environment" is selected.
2. ALTER ANY DATABASE AUDIT and ALTER ANY SERVER AUDIT permissions are not imported from script.
3. Copying a solution containing a database project with database references to external dbschema files to a new location may causes deployment to encounter an exception.

La versione del prodotto viene aggiornata al numero 9.1.40413.00

La release si può scaricare da qui:

http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed&displaylang=en

Tutti i dettagli sui miglioramente posso essere approfonditi qui:

http://blogs.msdn.com/gertd/archive/2009/04/22/rtm-of-vsdb-2008-gdr-r2.aspx

e qui

http://blogs.msdn.com/gertd/archive/2009/03/26/release-candidate-of-gdr-qfe.aspx