SQL Developer 2.1 Book Review and Migrations

Hi folks
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.

So, if you are new to Oracle, need a desk reference for Migrating to Oracle this book is a must have.

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

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

bocadmin_ww

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today