31 January 2011

SQL Developer Data Modeler 3.0 is Production

I'm please to say that SQL Developer Data Modeler 3.0 is now production.  The latest release is now available for download from OTN. There are various demonstrations available for you to get to know the new features and remind yourselves of other features.

See the main SQL Developer Data Modeler page on OTN for download links, new feature pages and demonstrations.

See the Oracle Press Release for more.

19 January 2011

SQL Developer 3.0 Early Adopter Now Available

On Tuesday 19th January, the SQL Developer team released a third early adopter for general use. This SQL Developer 3.0 EA3 now includes the full Data Modeler 3.0, which is also running in an early adopter cycle. The significance of this is that you can open and edit data models from within SQL Developer.  If you are not a modeler, then this extension should not be in your way, but if you like to move between the Data Modeler and SQL Developer and prefer to work with one tool, you can.

The best way to start, once you have started SQL Developer is File > Data Modeler. If you are familiar with the Data Modeler, then you'll recognize all the menu options there.  Create a new model based on a DDL file or a schema in the database, then select > Import >...
The browser menu is available under View > Data Modeler > Browser and if you want to change any preference settings, just select Tools > Preferences > Data Modeler!

If you have any feedback on the integrated offering, then post a message on the forums: SQL Developer Forum or the Data Modeler Forum.

12 January 2011

New SQL Developer 3.0 Webinar

I see that Lewis Cunningham is doing a free webinar on SQL Developer 3.0 for ODTUG in January.  Here is his post on the news http://it.toolbox.com/blogs/oracle-guide/sql-developer-30-new-features-webinar-43499 There is a link to register and a bit on how he uses SQL Developer in his day-to-day tasks.

Here http://www.odtug.com/apex/f?p=500:235:0::::P235_NEWS_ID:3061 is a list of free ODTUG webinars posted for 2011.

05 January 2011

Check for Updates in SQL Developer

SQL Developer is an extensible product - that means that you can write extensions (Java or XML) and include them in the product.  We have teams at Oracle, not part of the SQL Developer development team, doing just that.  The Oracle TimesTen, Data Miner and Rdb teams are all examples of this.  The first Oracle team to write a significant extension, was the Migrations team  - the only difference is that they subsequently became part of the SQL Developer development team and so work on other features in addition to the Migrations work - but I digress...
There are teams outside Oracle who are also writing extensions for SQL Developer.  You can see a list of them here - SQL Developer Third Party Extensions. Listed on the site they're pretty harmless; you can look at the list of extensions, review the individual websites and decide to download and include the extension or not. Extensions can also be added using Check for Updates. If your company allows you to download software from OTN and other sites, then this is an easy way to get new updates and extensions. SQL Developer is no longer using this Check for Updates facility to update the core functionality.  We only use it to advertise when there is a new release available and if we have a full new extension for download.  We also use the Check for Updates utility to help you download and install the correct drivers to connect to some third-party databases. In the end the Check for Updates utility is most useful for our customers and partners who are developing extensions.

Yesterday I added a number of new extensions to the Check for Updates Utility and updated a few of the existing extensions. 

How to Install Extensions
Start up your current release of SQL Developer and select the menu Help > Check for Updates.... Navigate to Step 2 to search through the various update centers available. You may be prompted for Proxy details if you have a firewall, once that is confirmed you'll be presented with the screen below. If you have a local file, which you have downloaded or even created, then you can select "Install from Local File" and complete the install. For Oracle, SQL Developer or customer created extensions, select the "Search Update Centers.
The choices are as follows:
  • Oracle SQL Developer: All version control extensions and  any announcements about the latest SQL Developer release.
  • Oracle Extensions: All extensions created by Oracle teams external to the SQL Developer team. This excludes extensions we automatically ship with the product, like the TimesTen extension.
  • Third party extensions:  This lists all extensions not developed by Oracle and includes some third-party database drivers.
All extensions are listed alphabetically and each has a description and version details. Select each extension you want to install and click Next.  Most extensions have license agreements associated with them. Read and accept each license.  Once you have agreed to all licenses, the extensions will be downloaded and installed. All extensions will be installed in the \sqldeveloper\sqldeveloper\extensions directory, where you installed SQL Developer.

Oracle does not test these extensions and you should be aware of what you are downloading and installing. You should also be aware that some extensions are free and some have a free trial period. Most if the extension developers are active on the  SQL Developer forum. on OTN so if you have queries about the extensions, ask them on the forum.