Andrei DANEASA

I recently read SQL Developer 2.1 book by Sue Harper, published by Packt Publishing (thanks Veena).

In a few words: I’m impressed. It’s a must read for everybody who’s working with Oracle.

For those of you who never used SQL Developer, Read the rest of this entry »

Based on my posts here it seems that I’ve been chosen by Packt to review the Oracle SQL Developer 2.1 book written by one of my colleagues here in Oracle who runs the SQL Developer team.

Considering this, stay tuned for the review just after the book will be launched as I will get it for free the day it is released.

Good luck!

Related posts:
%RELATEDPOSTS%

well… my colleagues from SQL Dev team will probably take out from the marketplace our competition. Having so many features for free is something that me and all the users are highly appreciating.

SQL Developer 2.1 EA1

Some facts of SQL Developer 2.1 Early Adopter 1: Read the rest of this entry »

On SQL Server 2005 Express Edition (I don’t know how’s on full version, never had a license for it) the default connection model is through named pipes and TCP/IP is disabled.

If you want to connect to it from Oracle SQL Developer using jTDS driver it will throw a generic connection failure, as he is trying just TCP/IP. The error looks like this:

In ordrer to enable TCP/IP you have to do a few steps:
Read the rest of this entry »

Trying to connect to SQL Server 2000 or 2005 from Oracle SQL Developer having Windows Authentication enabled on SQL Server will fail with:
“I/O Error: SSO Failed: Native SSPI Library not loaded. Check the java.library.path system property.”

The solution is simple: place a dll called NTLMAUTH.DLL (NT authentication) in your system path and restart SQL Developer. Windows/System32 is always a wise choice.

Where to get this DLL? It is shipped with JTDS here.

Is there another option? Yes, enable SQL Server authentication.

Related posts:
%RELATEDPOSTS%

I’ve been told that there is no way to connect to a SQL Server 2005 named instance from SQL Developer. That’s not necessary true, but it’s strange.

A bit of background information: SQL Developer is connecting to SQL Server through JTDS opensource driver. The driver said that it cannot support named instances. On the other hand, in the connection string, there is a syntax for named instance, like “instance=your_instance“.
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
%RELATEDPOSTS%

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!