Visual Studio 2005 Team Edition for Database Professionals | Duncan Mackenzie

Jeroen Ritmeijer

Very interesting, I cannot wait for the final version. I have had to do all this using various bespoke utilities and methodologies and it is nice that Microsoft is finally taking this part of the market seriously.

Any chance this works with Oracle as well?

Robert M - MSFT

Thanks for the interest. For V1, we will have support for Microsoft SQL Server 2000 & 2005. We have heard the request for having the tools work with other database platforms and are investigating that for a future release.

Robert Merriman
Test Manager
VS Team Data

rminder

Great looking product!

Our development team currently uses Visual Team Edition for Software Developers. Will we have to purchase Team Edition for Database Professionals separately when it's released? It sounds from the video that we will not have to. Is this correct?

prabhupr

In Production Database we have multiple tables which has PII (Personal Identity Information) Columns and we would not like to share that with DEV/TEST/UAT environment due to company terms and agreement + policies (as we plan to outsource the work)

Will there be any tool/functions/feature provided in the IDE which will generate "Fictitious Data" for each of these column(s) that we can call before the DB copy is sent to Dev/Test/UAT. May be we can provide an XML which will have Table + Column name combination which we identify as PII column, which we will provide as input to IDE which then does the magic.

prabhupr

To Generate Data, can I use UDF?
We have written some UDF's that we execute on our Database to MOCK current Data column, can those be invoked, if so, could you please let me know how?

prabhupr

Hi Matt, Gert

Will this tool (IDE) support "Unit Test Code generation" for existing code-base or its only for new code only?

prabhupr

Question on Re-factoring

==================

What if somebody wants to change the "Column Length"

1. Will the UI display appropriate Object that needs this change

2. If we are reducing the column length, will it warn about DATA Truncation

3. Not sure if it will also display UI dependencies (if I have Solution with one Project for DB and another project for UI) that needs change due to this column name/length change. Will it?