Oracle DB Project on Visual studio 2010 – Part3 Automated Build

This is a series of 3 Parts to talk about creating Oracle DB Project on Visual studio 2010, try to use it with some good features of the DB Project like refactor columns and lastly to use Automated Build with this project.

Part3: Do Automated Build with Oracle DB Project

Let’s Begin Smile

I will be assuming here that you already have Oracle DB and you were successfully created your Oracle DB project and you can deploy to the DB normally – if not then please see my Part1 and Part2

  1. Right click on your project and choose “Unload project”
  2. Then right click the project again and choose “Edit {your project name}.dbproj”
  3. Change (ProjectDefaultTargets =” Build”) To (ProjectDefaultTargets=Build;Deploy)
    1. Edit project1
  4. Save file
  5. Right click the project and choose Reload
  6. Now let’s do refactor again and change the column of Dep_ID to Dep_No_ID like the example we did in Part2
  7. Now check in without BUILD the project
  8. Go to the Team Explorer Tab
  9. Right Click Builds and choose New Build Definition
  10. for the example choose “Manual” in the trigger panel
  11. Now the coming part is the most important part
    1. In the process panel, expand advanced
    2. Process panel in build defination
    3. We will now put an argument that will be used by the build process to deploy the DB in the automated buil
    4. We need to add this in the MSBUILD Argument (change it to the right connection you have)
    5. /p:TargetConnectionString=”Data Source=ORCL;User ID=username;Password=UserPassword;Unicode=True”
  12. Save build
  13. Right click the build and queue it

Now you have successfully made Automated Build with Oracle DB Project

About nasrahmed

I'm TFS/ALM Consultant, Agile Associate and Speaker, I love Innovation and Microsoft Team Foundation System because it's the best system for ALM (Application Life Cycle Management). I'm interested in anything related to AGILE because I believe it's the best way for making software. Hope you enjoy my blog.
This entry was posted in Oracle DB Project, Visual Studio 2010 and tagged , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s