Jump to content
House Price Crash Forum

Archived

This topic is now archived and is closed to further replies.

Spot

Anyone Used Informix?

Recommended Posts

Where I work we're solid Oracle and MS SQL, however the powers that be are looking at a solution for a project which uses Informix.

I know NOTHING about Informix.

Just how different is it to Oracle or MS SQL ?

Would we be looking at the same sort of learning curve required for an Oracle DBA to retrain to MS SQL ?

ie: You can start running queries against a db without too many syntax differences but to actually start configuring and performance tuning there would be loads to learn.

Share this post


Link to post
Share on other sites

Depends what you are doing. Simple queries ok via odbc/linked servers etc, but maintenance wise its a bit of a curve... stay away if you can, and read up on it before you accept any responsibility for performance or maintenance.

Share this post


Link to post
Share on other sites

Depends what you are doing. Simple queries ok via odbc/linked servers etc, but maintenance wise its a bit of a curve... stay away if you can, and read up on it before you accept any responsibility for performance or maintenance.

I'm thinking more maintenance, tuning, etc from a DBA perspective.

We're a huge company so nothing would happen without us all having been on a shedload of training first. I'm simply looking for an idea of just how different it is to Oracle or SQL from anyone who may have been there already.

Share this post


Link to post
Share on other sites

Ah - you a DBA?

It is significantly different to SQL. Enough that it is going to be one of those quite tricky decisions as to whether you should volunteer for it or not. Personally I wouldn't, but then I have 10+ years on SQL and I don't really see where having a beginners knowledge of informix would really help - other than on occasion making me look like an even bigger tit than usual!

Share this post


Link to post
Share on other sites

  • Recently Browsing   0 members

    No registered users viewing this page.

  • 284 Brexit, House prices and Summer 2020

    1. 1. Including the effects Brexit, where do you think average UK house prices will be relative to now in June 2020?


      • down 5% +
      • down 2.5%
      • Even
      • up 2.5%
      • up 5%



×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.