As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.
Are there any tools available for Informix, similar to Query Analyzer for SQL Server?
We needed a Query Analyzer-like tool for an Informix project some time ago, and settled on RazorSQL, which is Java based, so it s completely platform independent (Windows, MacOS, Linux, etc). About half of the development team at our company uses Macs, so that was a requirement. On top of that, it can connect to any database through JDBC (29 different databases, according to the website).
I ve used it extensively on MySQL, SQLServer and Informix, and can confirm it works great on all of them. Before RazorSQL, I was using MySQL tools, and SQLServer Management Studio on a VM, but having a single tool to work with any DB you can throw at it is pretty nice. Also, for accesing Informix from a Mac, it s one of the few options available.
Not knowing anything about Query Analyzer for SQL Server, I could be being misled by its name, but...
We use Aqua Data Studio, a nice tool which supports different databases.
Jonathan s answer is excellent so I ll just confirm that Server Studio is a great albeit overpriced product.
Also to simply (and freely) run Informix Queries you could use Eclipse SQL Explorer
We need to pull some tables from an Informix SE database, truncate tables on Oracle 10g, and then populate them with the Informix data. Does a bulk import work? Will data types clash? I d like to ...
I am trying to get Informix working with NHibernate on windows 7. I have a connection string that works fine with informix now, it is this, Database=db;Server=server:port;uid=username;password=...
I had a quick question on serial data types used on primary key on informix db s. If I delete a row, will the serial key carry on counting or will it re-adjust for any rows that were deleted? So if ...
DB gurus, I am hoping someone can set set me on the right direction. I have two tables. Table A and Table B. When the system comes up, all entries from Table A are massaged and copied over to Table ...
What I thought would be a simple thing to solve has now bugged for quite some time. Now I need help from you guys. In Informix I have a table "temperatures" like this: locId dtg ...
Are there any tools available for Informix, similar to Query Analyzer for SQL Server?
I am using IDS 10 and I have a simple transaction table with the inventory changes with product ID, transaction time, volume, quantity and price. Is it possible to determine the FIFO valuation solely ...
I have a development project that requires us to be able to support informix data sources via ODBC. I ve downloaded the prebuilt Informix Virtual Appliance from the IBM website and am able see the ...
