APPLICATION LIFECYCLE MANAGEMENT FEATURES IN VS 2010

APPLICATION LIFECYCLE MANAGEMENT FEATURES IN VS 2010

Features	Professional	Premium	Ultimate
Architecture and Modeling
Diagrams that comply with Unified Modeling Language (UML) 2.1.2: sequence, class, component, activity, and use case	No	Read-only	Yes
Layer diagrams	No	Read-only	Yes
Code-generated sequence diagrams and dependency graphs	No	Read-only	Yes
Architecture Explorer	No	No	Yes
Architectural validation	No	Yes	Yes
Integration with work items in Microsoft Visual Studio Team Foundation Server	No	Yes	Yes
Extensibility for UML diagrams	No	Read-only	Yes
Diagnostic Tools
IntelliTrace	No	No	Yes
Static code analysis	No	Yes	Yes
Code metrics	No	Yes	Yes
Performance profiling	No	Yes	Yes
Schema comparison	No	Yes	Yes
Database Development
Database projects	Yes	Yes	Yes
Generation of test data	Yes: can run but not create plans for generating data	Yes	Yes
Database change management	No	Yes	Yes
Unit testing for database objects	No	Yes	Yes
Testing Tools
Web performance testing	No	No	Yes
Load testing	No	No	Yes
Unit testing	Yes	Yes	Yes
Coded UI testing	No	Yes	Yes
Microsoft Test Manager	No	No	Yes
Virtualization for ALM
Create and manage virtual environments	No	No	Yes with MSDN
Visual Studio Team Foundation Server 2010	Yes: available only for Visual Studio Professional with MSDN	Yes	Yes
Version Control	Yes	Yes	Yes
Build	Yes	Yes	Yes
Project Management	Yes	Yes	Yes
Integrated Reporting and Dashboards	Yes	Yes	Yes

STEPS TO CREATE PROJECT FOR BI/SSIS

STEPS TO CREATE PROJECT FOR BI/SSIS

Step 1: Open Visual Studio 2010.

Step 2: Go to View > Team Explorer

Step 3: Team Explorer > Connect to Team Project

Step 4:  Connect to Server

Step 5: Add TFS Server (if required)

Step 6: Select a Collection from Team Project Collections

Step 7: Click Connect

Step 8:  Team Explorer would be connected with the Collection you selected

Step 9: To Add Team Project into the Collection selected – Right Click on Collection in Team Explorer > Select New Team Project

Step 10: Enter Team Project Name & Description of Project (optional)

Step 11: Click Next > Select from the list Process Template to create Team Project

            Default selected is MSF for Agile Software Development v5.0

Step 12: Click Next > Select an Empty Source Control Folder option

Step 13: Click Next > Click Finish to create Project in TFS inside Project Collection selected

Step 14: Final Output in Team Explorer

                     

                 Team Explorer should be shown with the Project Name (in my case DemoProject) with Work Items, Reports (if configured on server), Builds & Source Control Section.

Step 15: Double Click on Source Control

            Following should be the Default Structure on Clicking on Source Control.

Step 16: Go to File > New > Project

Step 17: Select Template Database on left side > SQL Server > SQL Server 2008 Database Project

                At Bottom Right Select Add to Source Control > Ok (required to add code into source control TFS)

Step 18: Select Team Project into which you need to add the code

                Name a directory in which all the code will be created

Step 19: Below is the Output you need to obtain

Step 20: Right Click on Project Name > Check in Pending Changes

                This will commit changes on TFS Server > Note commands if required and say Check In

Step 21: below Steps are required only if Database is already created in SQL Server 2008 / SQL Server 2008 R2

Step 21.A: Go to Solution Explorer > Right Click on Project Name > Import Database Objects & Settings

Step 21.B: Select New Connection > Enter Details to connect to database

Step 21.C: Change the options to import (if required) > Start

Step 21.D: Import data > Finish

                This will import all the Table Scripts, Stored Procedures, Views, Triggers from the database connected.

Step 21.E: Following should be the structure shown of your database

Step 21.F: Right Click Project > Check In to commit changes on to TFS Server

Step 21.G: Right Click Project > Properties

Step 21.H: Select Deploy Section

Step 21.I: Change the Deploy Action to “Create a deployment script (.sql) and deploy to the database (required if database has to be deployed with the changes)

Step 21.J: Select Target Database Settings > Edit > Enter Details of Database > Ok

            Save the settings File

Step 21.K: Right Click Project > Check In

Step 21.L: Open the file in which you need to modify the scripts

Original Script: 

Modified Script:

Step 21.M: Commit your changes to TFS Server

Step 21.N: In-order to commit changes on to server database Right Click Project > Select Deploy

Step 21.O: Output Window will show all the changes committed to the database