Toad World adds value to your Toad experience by providing free education and revealing new functionalities — along with
time-saving tricks and tips.
Visit the community »
Quest Support
  • Global Coverage
  • Highly Skilled Engineers
  • Commitment to Customer Satisfaction
  • Flexible Support Offerings
Learn more »
Toad Extension
for Visual Studio
Visit shop.quest.com to buy this product online.
Buy online »

Toad Extension for Visual Studio

Extending Development to Oracle Through Visual Studio Extensions

Toad® Extension for Visual Studio extends the power of Microsoft's Application Development Lifecycle methodology to Oracle databases, enabling offline development in Visual Studio 2010 Professional, Premium and Ultimate editions. It enables you to:

  • Import Oracle database schemas into a Visual Studio project
  • Perform Oracle change management with ease
  • Synchronize and track application and database code
  • Ensure code quality and consistency
  • Gain uninterrupted team collaboration

The newest version, Toad Extension for Visual Studio v1.5.1 provides a set of Visual Studio tools that supports pre- and post-deployment scripts, tables with XML data type columns and those with with up to two levels of nested table type columns. It also now supports the use of synonyms and the ability to generate Oracle stored procedures with insert, update or delete statements.

Offline Development — Reduce the risks associated with rolling back changes and automate processes from within the familiar Visual Studio interface.

Application Change Management — Track and version your changes; ensure that your application code is in sync with the database.

Oracle Database Import — Create a new Oracle-based project and import your database schema.

Data Generation — Generate test data and perform unit tests prior to production.

Rapid Code Refactoring — Use an offline model of your schema to make changes and see what pieces of your project are affected.

Schema Compare and Change Merger — Compare the offline model of your schema to another model or live database and merge the changes.

Automated Daily Builds — Integrate database changes into nightly builds so your development environment is always in sync.

Version Control — Track and version each database schema object as a separate fragment through the Team Foundation Server.

Team Collaboration — Integrate Oracle development with the rest of your project for improved communication among team members.

Ensure your system meets the following minimum hardware and software requirements:

Visual Studio 2010Visual Studio 2010 Professional, Premium, or Ultimate (service pack 1 recommended)
Your system must meet the requirements for Visual Studio 2010. Refer to the Visual Studio 2010 documentation for its system requirements.
Team Foundation Server 2010Team Foundation Server 2010 must be installed to leverage Team Foundation Server's version control, build, and deploy features.
Database ClientOracle Client or Oracle Instant Client 10g to 11gR2
Database ServerOracle 9.2 to 11gR2
Oracle User Privileges

Import:

  • Ability to execute DBMS_METADATA.
  • If you connect as the same user as the schema you are importing, then you can import any object owned by that schema (except the CREATE USER statement).
  • If you connect as a different user than the schema you are importing, then the connected user requires the SELECT_CATALOG_ROLE or EXP_FULL_DATABASE roles.
  • Importing the CREATE USER DDL requires the SELECT_CATALOG_ROLE or EXP_FULL_DATABASE roles. This is applicable regardless of whether you connect as the same user as the schema you are importing. Toad Extension automatically creates a user script if these roles are not available to the connected user. However, this is only a placeholder script that does not include the actual user settings from the database.

Deploy:

  • Ability to create, alter, and drop objects.
  • Ability to reference tables involved in a cross-schema foreign key.
  • Ability to create public synonyms.
Additional Software

Adobe Acrobat Reader 7.0 or later (to view the Installation Guide)

Microsoft Internet Explorer 6.0 or later (to view the Release Notes)


Language Supported:

  • US English