Andrei DANEASA

As I had a request and I must agree it really makes sense, I developed a console version of the DBF2Oracle tool. Functionality is the same, just that you need to give it parameters from command line.

Usage is:

Read the rest of this entry »

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 »

Last week I’ve been in Nice. In the evening, I was sitting with some colleagues waiting for the beer at some bar in the harbor, and the bartender came with the beers and was extremely pleased to have 6 guys at his table, because he was gay. When we asked him to take us a picture, he refused because he wanted to be in the picture.
Here is what we get, damn it:

N.B. None of the us is gay, cross my heart !

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.

I wrote a lot how to install loopback adapter, how to set the ip address (either manual or automatically), how to add an entry to hosts file (either manual or automatically). Now let’s add all together into a single script.
The script will do the following:

• call DevCon to install Microsoft Loopback Adapter (you need to download DevCon and save it in the same folder as the script)
• set the IP address and mask for the recently installed loopback adapter
• dinamically read from Windows folder the hosts file
• dinamically read the hostname
• add a new entry to the hosts file with the supplied IP address and hostname
• ping the hostname and check if the supplied IP address is responded
• MOST IMPORTANT: everything is dynamic and automatic. You don’t need to edit the script before each install. Just run it!

You can download this script here: Read the rest of this entry »