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

STEPS TO MIGRATE VSS 6.0 PROJECTs TO TFS 2010

STEPS TO MIGRATE VSS 6.0 PROJECTs TO TFS 2010

Step 1: Keep your “Data” Directory of VSS 6.0 ready and importantly “VS 2005 should not be installed on the same machine”.

Step 2: Bind the “Data” Directory to VSS 6.0.

Step 3: Once Bind verify the Projects.

Step 4: Uninstall VSS 6.0 from machine > Restart if required (Recommended).

Step 5: Install VS 2005.

Step 6: Install VSS 2005 + SP1

Step 7: Verify the project in VSS 2005

Step 8: Create “settings.xml” file with the below mentioned content

     

           

                  C:\VSSDatabase

">

           

           

            $/FolderA

">

           

     

     

      

    

You need to have following .dll files at same directory where above file is created:

1.       Microsoft.TeamFoundation.Client.dll

2.       Microsoft.TeamFoundation.Common.dll

3.       Microsoft.TeamFoundation.dll

4.       Microsoft.TeamFoundation.VersionControl.Client.dll

5.       Microsoft.TeamFoundation.VersionControl.Common.dll

6.       Microsoft.TeamFoundation.WorkItemTracking.Client.dll

Above .dll files can be found at C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\ReferenceAssemblies\v2.0

Step 9: Once above file is created, run the following command in Visual Studio Command Prompt > VSSConverter Analyze settings.xml

            It will create Analysis.xml output file, which will be used for Migration to TFS

Step 10: Now, Create “tfs_migration.xml” file with the below mentioned content

     

           

                  C:\VSSDatabase

">

                  C:\Migrate\Usermap.xml

">

           

           

                  $/FolderA

" Destination="$/TeamProjectA">

           

     

     

            server_name

" port="port_number" protocol="protocol" collection="tfs/DefaultCollection">

     

Step 11: Create a project in TFS named TeamProjectA (if project not created mentioned in above file)

Step 12: Run Command “VSSConverter Migrate tfs_migration.xml” in VS Command Prompt.

STEPS TO ADD ANALYSIS PROJECT IN TFS 2010 USING VS 2008

STEPS TO ADD ANALYSIS PROJECT IN TFS 2010 USING VS 2005/VS 2008

For VS 2005:

Step 1: Install VS 2005 Team Explorer on local machine. http://www.microsoft.com/en-us/download/details.aspx?id=7203

Step 2:  Install SP1 for VS 2005 (VS80sp1-KB926601-X86-ENU.exe) http://www.microsoft.com/en-us/download/details.aspx?id=5553

Step 3: Install SP1 for VS 2005 Team Foundation Server (VS80sp1-KB926738-X86-ENU.exe) http://www.microsoft.com/en-us/download/details.aspx?id=15789

Step 4: Install VSTS 2005 Forward Compatibility Upgrade (VS80sp1-KB979258-X86-INTL.exe) http://www.microsoft.com/en-us/download/details.aspx?id=3263

For VS 2008:

Step 1: Install VS 2008 Team Explorer on local machine. http://www.microsoft.com/en-us/download/details.aspx?id=16338

Step 2: Install SP1 for VS 2008 (VS90sp1-KB945140-ENU.exe) http://www.microsoft.com/en-us/download/details.aspx?id=10986

Step 3: Install VSTS 2008 Forward Compatibility Upgrade (VS90SP1-KB974558-x86.exe) http://www.microsoft.com/en-us/download/details.aspx?id=10834

            As TFS 2010 introduces the notation of Team Project Collections. After the installation is completed successfully, you should provide the entire URL to connect to TFS 2010 Server.

            You can express the connection string as follows:

http://:// (e.g. http://TfsServer:8080/Tfs/ProjectCollectionName)

            The is an optional path for the TFS web sites specified by the administrator during setup. By default it is “tfs”.

SQL SERVER REPORTING SERVICES ERROR WHILE CREATING TEAM PROJECT IN TFS 2010

SQL SERVER REPORTING SERVICES ERROR WHILE CREATING TEAM PROJECT IN TFS 2010

                To perform this procedure, you must be a member of the Reporting Services System Administrators  group

Step 1: Open Team Foundation Server Administration Console

Step 2: Select Reports in Administration Console

Step 3: Copy the URL at Report Manager

Step 4: Copy the URL into browser and Login with the Administrative Credentials

Step 5: Click on Folders Settings

Step 6: Click New Role Assignment

Step 7: Enter the DomainName\UserName for the user to give access on the reporting services

Step 8: Select one or more roles to assign to the group or user section >Team Foundation Content Manager

Step 9: Click Ok to get Final Output

STEPS TO CREATE TEAM PROJECT IN TFS 2010

STEPS TO CREATE TEAM PROJECT IN TFS

Using Visual Studio 2010 Team Explorer

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:

a.      a. If you have Project which is already created but not in TFS follow below steps

Step 1: Open Project (needed to be added into TFS) in VS 2010

Step 2: Right Click Solution > Click Add Solution to Source Control

Step 3: Select the Team Project Location from the Window that Pop ups

Step 4: In Section “Type a name for Solution Folder” type “SourceCode” to create a Folder “SourceCode” at the same level at BuildProcessTemplate

             “SourceCode” folder needs to be created to keep all Project files in single directory inside a Project Folder. This is an Option Step just to manage your Source Code.

Step 5: Click Ok > Final Output should be as below

Step 6: Right Click on SourceCode Folder > Checkin Pending Changes inorder to commit changes from local folder to TFS Server

Step 7: Write an comments if required and Check In

Step 8: Right Click on SourceCode Folder > Remove Mapping

             This is an important step as this is required to remove any mappings or any reference that is from local machine to TFS Server. Once done with this any other user can do mapping of this project on their local machine.

Remove Mapping > Yes

a.   b.  If creating a New Project follow below steps

Step 1: While creating a project check on the option Add Solution to Source Control

Step 2: Select the Team Project Location from the Window that Pop ups

Step 3: In Section “Type a name for Solution Folder” type “SourceCode” to create a Folder “SourceCode” at the same level at BuildProcessTemplate

            “SourceCode” folder needs to be created to keep all Project files in single directory inside a Project Folder. This is an Option Step just to manage your Source Code.

Step 4: Click Ok > Final Output should be as below

Step 5: Right Click on SourceCode Folder > Checkin Pending Changes inorder to commit changes from local folder to TFS Server

Step 6: Write an comments if required and Check In

Step 7: Right Click on SourceCode Folder > Remove Mapping

           This is an important step as this is required to remove any mappings or any reference that is from local machine to TFS Server. Once done with this any other user can do mapping of this project on their local machine.

Remove Mapping > Yes

Final Output: