SQL Developer 2.1 Book Review and Migrations
By jasonw on Jan 21, 2010
I won't apologize for taking so long to blog again, since that is what everyone does. You'll be fine.
Anyway, I wanted to write a quick review on Sue Harper's new book "Oracle SQL Developer 2.1".
First of all, excellent book. Sue does a great job of hands on deep dive examples of the new (and old) features of SQL Developer. She has a lot of attention to detail and doesn't skimp. In this book you'll get hands-on experience in everything from setting up the product to migrations. She even shows you how to custom add JDBC Drivers for other data sources.
There is an excellent section on Data Modeler, one of the newer features of the product. Also are extensive coverage on APEX integration and legacy migration, my personal favorite. In fact, I have just come back form a customer visit where we ran the tool through the paces for a Sybase Migration. There is great improvement on the Stored Procedure translations and getting of Sybase is easier than ever.
Here is a quick quote from the books site:
What you will learn from this book
Build complex queries based on a number of tables using visual Query Builder
Assess the health of your database, data structure of your application, and data in that application with built-in as well as user-defined reports
Create, compile, and debug PL/SQL code and explore available features to facilitate writing PL/SQL code
Integrate your SQL Developer with open source version control systems CVS and Subversion, which allow checking out of files from a repository, editing, and checking them back in
Enter and execute your SQL, PL/SQL, and SQL*Plus statements with the SQL Worksheet interface
Produce easily replicable scripts that copy and move data from one database instance to another, or from one schema to another
Create advanced database connections using a variety of connection and authentication types available for Oracle as well as non-Oracle databases
Create, review, and update database schema designs with SQL Developer Data Modeler
Augment your environment with features that are specific to your needs by extending your SQL Developer with XML structured user-defined extensions
Monitor and manage your Application Express applications by integrating with SQL Developer
Set up an easy and quick migration environment for your database schema by using the migration repository
Browse and review non-Oracle databases, before using the migration environment to migrate and consolidate databases on the Oracle platform