Oracle DB Project on Visual studio 2010 – Part1 Create Oracle DB Project

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

Part1: Creating Oracle DB Project using Toad Extensions for Visual studio.

First you will need to have

  1. Oracle DB Server (for this tutorial I used Oracle Enterprise 11g R2)
  2. Toad Extensions (Available from here http://toadextensions.com/index.jspa)

Let’s Begin Smile

  1. Open Visual Studio.
  2. New Project (Choose Database –> Oracle (Quest Software)).
  3. Configure Build/Deploy Wizard Screen will show up.
    1. Here you are configuring the project settings and how the deploy output will be and its connection.
  4. Choose the output type for the deploy (Script & Database for example)
  5. Click on New Connection to setup where you will deploy your DB.
    1. Server name is the name of the connection in the Tnsname.ora (like the highlighted yellow word in the below pic)Tnsnames
    2. Write your user name and password
    3. Oracle New Connection
  6. Next Screen choose to “Import from database”
    1. to import the schema you want
  7. In the next screen of “Import Options” write the connection to the DB where you want to import its schema to use it with the DB that you identified before to deploy on it
    1. Of course both can be same DB

Now you have successfully Created Oracle DB Project.

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s