Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Support Oracle databeses

grafity's profile image grafity posted 5 years ago in General Permalink
This program seems a beauty, but also i have the need to control an Oracle database. This planning on supporting databases Oracle?

Thanks.
ansgar's profile image ansgar posted 5 years ago Permalink
I had planned Oracle in the past. But to be honest, I think HeidiSQL cannot compete with commercial Oracle clients, could it?
grafity's profile image grafity posted 5 years ago Permalink
Are you crazy. Pardon the expression, but I think HeidiSQL now is better than many Commercial options.

The only outstanding of the commercial and more popular GUI for Oracle is that you can see at once their relationship to another table and navigate directly to that another table by placing the mouse cursor over the name of that table as it is shown as a link.

I think if HeidiSQL supports Oracle, would be one of the best free options.

Hopefully it will be free forever since it is becoming in favorite databases administrator among developers.

I mention this in a tutorial I wrote for Dolibarr in OpenShift, in which I emphasize the SSH connection HeidiSQL.

http://wiki.dolibarr.org/index.php/Cloud_with_Redhat_OpenShift_Flex

Thanks...
Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 5 years ago Permalink
Thanks for your words. I appreciate that.

Is there some C API .dll supporting Oracle on Windows, similar to libmysql.dll for MySQL?
ansgar's profile image ansgar posted 5 years ago Permalink
As I just read here, that would need these files from Oracle's instand client:
* oci.dll
* oraocci11.dll
* oraociei11.dll
* orasql11.dll
All in x86 and x64 versions. But that documentation is for Delphi's internal database wrapper, which I am not going to use in HeidiSQL. I would have to implement my own wrapper, like I did for MySQL, MSSQL and PostgreSQL. I will definitely need some documentation for that oci.dll .
quixrick's profile image quixrick posted 5 years ago Permalink
Hi, I'd just like to second this thread. I've used a myriad of different MySQL management programs over the years, including several paid ones like SQLYog. But once I discovered HeidiSQL, I've never looked back. It is the best I've found and it's free-ninety-free, which is my favorite price.

Lately I've had the pleasure (sarcasm) of using Toad and SQLDeveloper to manage Oracle databases stuff. The only thing I think while I'm using them is how much I miss HeidiSQL. I check back here regularly to see if there's support for Oracle in the hopes that there will be one day.

I mean this as a sincere compliment; You have done such a great job on HeidiSQL. I do hope to see one day, that support for Oracle databases happens.

-Rick
apockhs's profile image apockhs posted 4 years ago Permalink
Hi ansgar, I found some documentation from oracle help center, maybe it can help you.

Call Interface Programmer's Guide - Appendix D

Regards

As I just read here, that would need these files from Oracle's instand client:
* oci.dll
* oraocci11.dll
* oraociei11.dll
* orasql11.dll
All in x86 and x64 versions. But that documentation is for Delphi's internal database wrapper, which I am not going to use in HeidiSQL. I would have to implement my own wrapper, like I did for MySQL, MSSQL and PostgreSQL. I will definitely need some documentation for that oci.dll .

lubber's profile image lubber posted 3 years ago Permalink

Is Oracle support still in consideration or just in progress or dropped?

Please login to leave a reply, or register at first.