SQL Developer 3.1 EA1 - Schema Diff

It was great showing everyone last week at OOW what was coming.  The only thing better is giving people the software to start using.  Now that it's out, I'll do some blogging to get some of the new areas pointed out.

One of the major areas of work in SQL Developer 3.1 is the diff generation between 2 schemas.  This is completely rewritten from the ground up.  That's interesting but maybe more interesting to you is that it no longer requires the change management pack.  That means you are free to use this feature now without any worries of what is licensed and on which databases.

It's still in the normal place in the Tools menu.  The first screen now gives you more control over what you are going to want to consider is a difference.  For example, matching constraints based on the name or the definition.  If I have a check contraint in two databases both doing the same things but have different names, it will not be flagged if I choose contrants by definition.

At the end of the wizard, there is a new tree representation of the differences between the schemas.  The tree shows everything possible.  Unchecking the "Show Equal Objects" will restrict to just the ones with changes.  Then in the lower portion of the screen, you get the standard diff window that highlights the changes in the objects.

Clicking the script tab you'll see the alter statement.

The finally clicking the SQL icon in the toolbar will generate the script to sync the two connections.

Oracle Express Edition 11.2 is here!

Oracle XE 11.2 is now available on Windows 32 and Linux 64.  It can be downloaded here.  I'll be shortly putting together another VirtualBox image so it can be used on other platforms.  This is also a great database to try out the Learning Library labs on.

In case anyone doesn't know, Oracle Express Edition is the free database.  The limitation has gone up to 11.

3 Upcoming OTN Developer Days

There's a few more of the OTN Database Developer Day free training events coming up.

The first is next week in Reston,VA. This is the full four track event.  If you are able to make it, it's a great chance to talk to some of the development staff that run the event.  Mike Hichwa will be giving the keynote.

The agenda for this even can be found here: http://www.oracle.com/us/dm/h2fy11/77471-wwmk11054222mpp004c004-oem-452411.html?ssSourceSiteId=otnen


The second and the most widely available is going to be on September 13th at 9am Pacific.  This  will be our first virtual one version of the event we've been doing live for over a year.  The virtual event is great for people that can't make it to the live ones.  You can register here:
https://oracle.6connex.com/portal/database/login/?langR=en_US&mcc=SQLDevblogVDDDB9132011

The agenda for the day is here: https://oracle.6connex.com/upload/124/483/1314393443040_67_.pdf

The lastly is a Database only track coming up on September 20th in Calgary.  For this day, we are only running the 1 track and it's database focused.  There's Application Express, Times Ten, XML DB, and of course SQL Developer and Modeler.

The agenda for this even can be found here: http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=140137&src=7328803&src=7328803&Act=14


As always, all these events use the Database App Development VM. If you've not heard of it before, it's a VM that we build which is preconfigured with all the software and material for most of the labs ( minus .NET and jdev )  It's an 11.2.0.2 EE version of the database with Application Express 4 ( yes we're updating it ), SQL Devleoper and Modeler 3, Times Ten 11r2, the APEX Listener, and all the labs themselves.  Even if you can't make one of the events give the labs a try yourself but getting the VM from here:  http://www.oracle.com/technetwork/community/developer-vm/index.html

Apex Listener + WLS + Serving static files from /i/

A common thing that people ask about is setting up the images directory in weblogic. The documentation explains how to generate an i.war file then deploy it.  This work great until the need arises to also host additional files like custom javascript or css.  This is a short video of how I setup the /i/ for my servers.  This setup lets any content in the directory be served out.  The one assumption is that you already have web logic setup and running.  In my case, the http server is on port 8080.  

Here's the xml file that is in the web.xml:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://

java.sun.com/j2ee/dtds/web-app_2_3.dtd">

<web-app> 

</web-app>

New and Improved!

   The SQL Developer Exchange , http://sqldeveloper.oracle.com,  has been out there almost since the beginning of the tool.  It's our way to allow users to log requests and have other vote on them.  Then we each release pick off some and put them into the product.  It's been basically unchanged since day 1.  This week I've built a new set of screens which hopefully look better and are easier to use.   We have implemented over 400 requests from users.  The exchange is have a bit of a facelift and if anyone would like to test out the new Exchange go here https://apex.oracle.com/pls/apex/f?p=43135:1 .  This is the same tables and data underpinnings so if you log or rate a request it will show in both place.