Toad World

Good news!! The much anticipated update to Toad Extension for Visual Studio is here! I know many of you have been patiently waiting for an update to add support for several things, so this should be a very interesting release. Here’s the skinny on what’s been added. Click on one of the links below to download the latest version and try it out for yourself.

• Additional Oracle Data Types Supported — Toad Extension now supports Character Large Object (CLOB), Binary Large Object (BLOB), and User-Defined data types.
• Redirect Schema Compare & Deployment — You can now redirect schema compare and the deploy engine to map the schema of a project to a different schema in the database.
  • From the project properties screen, on the project settings tab, check the box underneath the “Default Schema” setting. This means that I can compare against or deploy to a different schema than what’s in my project. (e.g.: my project has “SODA” but I want to deploy at a customer site where their schema is named “SODAMFG.”)
• Command Line Build Scenarios — Build and deploy projects from the command line.

New users can check out the trial here: http://www.quest.com/toad-extension-for-visual-studio/

Existing customers can download the update free of charge here: https://support.quest.com/Default.aspx

That’s right, folks – you heard it here first! Please welcome the newest addition to the Toad family: Toad Extension for ECLIPSE!

For many years, we’ve heard this request: “when will you create a Toad that runs in Eclipse?” An increasing number of you – the loyal Toad users – are working with Java in Eclipse and we want to make your database development experience in Eclipse a lot easier. We believe that as Oracle assumes the stewardship of Java, there will be even more interest in Oracle as the database of choice for enterprise Java development. And at Quest, we believe that having choices makes the world a better place – for everyone. So given the huge popularity of Eclipse among Java developers, there’s no better place for this new Toad to stretch its legs!

Toad Extension for Eclipse is currently in beta and will later be released as freeware. It’s open for anyone to try! Let’s take a moment and take a walk through the newest addition to the Toad family!

A new perspective!
Once you install Toad Extension for Eclipse, you can find it under the Window > Open Perspective > Other menu. With that open, let’s take a look around.

A new perspective - Toad in Eclipse

1. After opening the perspective, you’ll need to create a new connection to Oracle. You can do that from the Connections window by clicking on the “New Connection” button on the left.
2. To create a new package/function/procedure (etc), use the Stored Procedure Editor. To write a query, use the SQL Worksheet. If you want to browse an object (i.e.: view the data in a table or see the DDL for an object), use the Open Describe Objects button.
3. The Schema Browser shows you all of the objects in your schema and can be filtered to help you find specific items.
4. The tabbed document area is where all of your windows will open. Note that there are tabs within each new document which give you more detail.
5. The outline view will help you traverse large sections of code
6. DBMS Output and SQL Monitor windows can be docked to the lower section of the screen. Use them to view output and to see the queries that are running behind the scenes.
7. Both the DBMS Output window and the SQL Monitor window have an on/off switch (the light bulb). By default, it is turned off.
8. PL/Doc is similar to Java Doc and useful for viewing object details such as columns, data types and column/table comments.
9. For those of you using Team Foundation Server to manage source code and work items, you can install Team Explorer Everywhere from http://www.microsoft.com/visualstudio/en-us/products/2010-editions/team-explorer-everywhere

An Open Future
Toad for Oracle was (and is!) developed through close interaction with end-users; over time has become the most popular database development IDE for Oracle. Here we are – over 10 years later – and nothing has changed! We want to hear what you have to say about Toad Extension for Eclipse! What do you want to see in Toad Extension for Eclipse? How can we make it better – for you!? We will be listening closely and we will release often to respond quickly to your requests. The future is open! Where do you want to go?

Let’s hear it!

–The Toad Team

We’re pleased to announce that “Project Fuze” has become part of the Toad family! Take a look at the new build working inside of Visual Studio 2010 RC1!

Quest’s very own Claudia Fernandez was interviewed in a panel discussion about ProjectFuze. Listen in to find out what she has to say about offline development for the Oracle world.

This is a great article by Visual Studio Magazine regarding which Oracle database provider to choose…

http://visualstudiomagazine.com/articles/2009/12/22/microsoft-sunsets-net-for-oracle.aspx

Last week Microsoft released Visual Studio 2010 beta 2 with all new branding. The team editions have been replaced by Ultimate and Premium editions. Project Fuze now runs on both Ultimate and Premium editions of Visual Studio 2010. You can download the latest beta refresh of Project Fuze from the www.teamfuze.net download forum. In the coming weeks the beta will be refreshed with some great new features like unit testing of functions and stored procedures.

– the TF Team

Ready to upgrade to the latest & greatest? We’ve been hard at work for many weeks now, preparing a refresh for the Project Fuze beta. I’m pleased to report that it’s finally ready to go.

You can download the update here: http://teamfuze.net/ann.jspa?annID=261.

Enjoy (and let us know what you think)!

Take a second to visit the MSDN Channel 9 community and watch the latest demo. Thanks a lot to Microsoft for the invitation!

http://channel9.msdn.com/shows/10-4/10-4-Episode-30-Database-Schema-Extensibility/

–Daniel