Visual Studio Team Edition for Database Professional Live Meeting Q&A Responses

Are you considering adding the ability to create, manage & synchronize Logical Models (in addition to the Physical Models that can currently be done today)?

[Cameron Skinner] V2 is all about Logical / physical modeling

Also, will Microsoft be making the test data generator available as a standalone utility?

[Cameron Skinner] Not currently planned 

is their support for genrating data  for CLR UDTs?

[Cameron Skinner] The data generation mechanism is extensible, so this is possible via customization. 

Will there be additional reports for TFS for database items?

[Cameron Skinner] No, but the database items will be visible just like any other source code.

Intellisense support?

[Cameron Skinner] Not in V1, but we will have intellisense in V2

Are you going to provide (security) guidance about the schema being stored as unencryted text files?

[Cameron Skinner] We’ll cover this in white papers 

Quick suggestion: for training and/or documentation addressing "ethics" and responsbilities for DBAs/devs re data/compliance/governance/privacy. (Also, did test data generator support XML data type?)

[Cameron Skinner] No, we’re not generating data for XML data types at this point, but again, this can be done by creating a custom generator.

Is the isolated "sandbox" version aware.  eg  Create a sql 200 sandbox and try to add a SQL 2005 t-sql oblect like complex types?

[Cameron Skinner] Yes, we won’t allow you to do this. The SQL 2k project template is _very_ different than the 2k5 template

Build Process

Will this include samples to automatically build and deploy the database?

[Cameron Skinner] BOL cover this in detail

Database Model – What support will there be for the following?

Security/role settings

Replication setup/state (e.g. Transactional, Merge Replication)

Full text search

Extensibility Kit

Will this include samples for custom data generation?

[Cameron Skinner] Yes

Refactoring

Are more complex refactorings being looked at e.g.

. http://www.agiledata.org/essays/databaseRefactoringCatalog.html

[Cameron Skinner] Yes

Is there an extensibility model in place to add new refactoring types?

[Cameron Skinner] Refactoring is implemented in this way, but will not be made public in v1. This is something we will want to enable post v1

Licensing

Will an additional copy of Team System for Data Professionals be required for the build server? Or if all users of the build process have a license will this not be required?

[IJK] No, but licensing is per user. If a user is accessing TFS they need a CAL except for admin tasks.

Unit Testing

Test Management – vsmdi files

[Cameron Skinner] We sit on top of the existing testing framework, so the following two questions behave exactly like they do for C# and VB.NET

i. How will the test id for the database test be created? Will this be calculated in a similar way to the unit tests?

ii. What will the storage location for the database tests be?