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
