Andrei DANEASA

I expected this release for some months, but didn’t have the time to test it yet. What you can do? Here’s the official description:
“SQL Developer Data Modeling offers a full spectrum of data and database modeling tools and utilities, including Entity Relationship modeling, Relational (Database Design), Data Type and Multidimensional modeling, full forward and reverse engineering and code generation. It includes importing from and exporting to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of Design Rules.“.
Read the rest of this entry »

If you are migrating a database with business logic inside (typically SQL Server and Sybase) to Oracle, it can happen that translation process to freeze during converting a particular stored procedure or trigger.

The problem come up when finding lots of IF… ELSE loops inside the stored procedure and this will be solved in the next release of SQL Developer.

The solutions, as Dermot O’Neill said, are:

• comment the ELSE keywords, translating it into /* ELSE */, then uncomment if after translation
• delete the procedure from the captured model and skip it during translation
• comment the code inside the procedure, or comment just some IF… ELSE loops

Good luck !

Read also

I’ve been asked many times if there is possible to install Oracle Application Express on Express Edition of 10g database, both of them being free products. The answer is YES, and the procedure is quite simple, as very well indicated on Oracle website

The steps would be: Read the rest of this entry »

Starting with 9th of June, a new version of SQL Developer was launched. This is more a patchset to previous version, solving a significant number of bugs.
I am very happy that the “Bug 6994152: ORACLE_HOME environment variable sometimes has an adverse affect on migrations” was solved, this being a very frequent topic on the migration forum. Now there is no need to create the .CMD file to overwrite ORACLE_HOME.
Another useful and very demanded feature is auto-expand of the connections list when open the tool.
Read the rest of this entry »

Sometimes, upgrading Oracle SQL Developer will not import your existing connections. You can have in the end an empty connection list. In order to import it, you just need to copy the connections.xml file from your old location like this:

to your new location like this:

Another version would be, when upgraded version of SQL Developer is asking for the path to the connections file, just provide him the path to the old version.

Good luck!

UPDATE 2008-11-05! A console version is available here

Since I had more and more requests for DBF migrations to Oracle and SQL Developer offers no support for DBF migrations, I decided to make a tool to ease my work. There used to be a command prompt tool (ImpDBF.exe) which generates the equivalent table for Oracle and SQL*Loader scripts for importing the data. This tool was for Oracle 7 and 8 and I don’t have the source code for this tool.

The workaround was to create a frontend for that tool that can also fix problems in generated files.
The result is the like this:

Read the rest of this entry »

Ionut recently showed me a very nice place to download IT books. I personally found lots of very useful ones to use. Check this out:
http://www.xpressionsz.com

Enjoy.