Re: [Info-Ingres] FW: Ingres Development Sprint, June 2009.


On Jun 3, 2009, at 5:53 AM, Roy Hann wrote:

Martin Bowes wrote:

Hi Dave,

Merging RW and SQL ... Dude, we only have a day and a half...!

Still, it's an idea.

On the other hand, there are loads of open source query tools out there.
Does anyone have a favorite that almost-but-doesn't-quite work with
Ingres? That might be a good day and a half project.

--
Roy


Roy,

Although I'm not fortunate enough to attend the Sprint, I do have a
favorite query tool I've been using since 2002.

Here is my situation. Every day I work with Ingres, Oracle, SQL Server,
Postgres, Firebird, and MySQL.

I'm familiar with the distributed tools of all these databases, and indeed
I manage all these databases on a daily basis.

The query tool I use is DbVisualizer, made by Minq Software out of Stockholm.

Ingres is NOT listed on their compatible databases and JDBC driver pages:

http://minq.se/products/dbvis/doc/databases.jsp
http://minq.se/products/dbvis/doc/drivers.jsp

It works fairly well with Ingres, but not as well as it does with Oracle. They
have a published plug-in management interface. This is evident when you access
Oracle and you get all sorts of shiny options to create and manage users, schemas,
tables, storage, etc. SQL Server has the same.

It is NOT open source, but it has a "free" edition that is missing some very
nice DBA-friendly import/export and table editing features. I believe the
paid edition is worth the price. And many of my clients manage nicely with the
free edition.

Lastly, I have NO affiliation with Minq Software besides being a long- time happy
customer.

Cheers,

Michael Leo
Director of Managed Services
Kettle River Consulting

MLeo@xxxxxxxxxxxxxxxxxxxxxxxxx
+1 612-859-2108 (cell)
+1 612-605-1978 (fax)

.

Relevant Pages

  • Re: General SQL/ODBC question
    ... Download WinSQL from http://www.synametrics.com/winsql. ... > I am trying to teach myself SQL programming on my home PC using Windows XP ... > a driver and a connection to a database here in order to use the Query Tool. ... I do not think I have the 'database' required. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Best Oracle front end / Query tool for power users
    ... visual query tool is good for novices and the SQL view provides more ... which is a problem for power users. ... Easy for novice user, but has advanced user features (ie - you can ... Brio/ Hyperion - This is probably my favorite query tool. ...
    (comp.databases.oracle.misc)
  • Crystal 10, Manually Changing, SQL Changes, Blank Report - bug?
    ... In Crystal 10, I have a report that runs well, but needs one more ... So I reloaded the original report that runs, and copied the SQL ... Crystal, and pasted it to my query tool, and it was broken. ... original SQL, and still broken. ...
    (microsoft.public.vb.crystal)
  • Re: [Info-Ingres] FW: Ingres Development Sprint, June 2009.
    ... favorite query tool I've been using since 2002. ... Stockholm. ... I'm familiar with DBVisualizer too. ... UK Ingres User Association Conference 2009 will be on Tuesday June 9, ...
    (comp.databases.ingres)
  • Re: SQL vs. OS/400 queries
    ... I've found the prompted mode of QM to be close enough to Query/400 for ... for SQL, but this approach was not optimal at all times for SQL. ... statement capability. ... Now if some new UI query tool were to come out to ...
    (comp.sys.ibm.as400.misc)
Loading