Migration tools for moving IngresII 2.5 data and ABF to Oracle

DATABASE

    Sponsored Links

    Next

  • 1. [Info-Ingres] For Roy
    Roy: I need to contact you. Could you email me please? Thanks Roger **************************************** Roger Hill **************************************** Roy:<br /><br />I need to contact you. Could you email me please?<br /><br />Thanks<br />Roger<br />****************************************<br />Roger Hill<br />****************************************
  • 2. C API reference docs ...
    Dear Group, I'm investigating the dbms list for support of an application generation product currently in development, and in the process, I'm looking at (amoung various other DBMS's) Ingres. Can anyone point me to a reference document which describes the C API binding, and the SQL language as implemented in INGRES, preferably in .PDF format which I am able to readily download??? I'd dig (Google) harder, but I figured in this group, someone already has their fingers on such a doc, and would be willing to share it ... Thanks in advance for any pointers ... Cheers, Rob.
  • 3. [Info-Ingres] Auto generated sequences
    Hi Niko, > are they just for convenience or do they eliminate the concurrency > issues associated with unique key generation? > Because I see that they take logical locks. There certainly convenient, and less prone to lock problems. The sequence largely lives in the server itself so a logical lock is taken in there. So speed of access should be dramatic...unless of course you set the nocache options. > Is it possible to introduce gaps between the sequence by means of > server failure, aging out of the shared pool in case of caching, > or programatically? Yes to all the above. But quite frankly gapless sequences are just not worth the hassle. Martin Bowes
  • 4. IIMONITOR question
    Hi We use an old Ingres version on Alpha/VMS, II 2.0/0308. When I'm in IIMONITOR and run the "show sessions" command, is there any way I can identify my own session ID (in other words the session ID of the IIMONITOR) ? Thanks David Greenberg

Migration tools for moving IngresII 2.5 data and ABF to Oracle

Postby spammeiloveit » Wed, 22 Apr 2009 00:32:03 GMT

We have some medium sized IngresII 2.5 databases with ABF
applications, still running on Reliant UNIX 5.43.  We need to migrate
to some supported software on modern hardware, such as Oracle on
AIX.

Is anyone aware of migration tools to achieve this that would still
work with such an old unsupported version of Ingres?  Where might one
obtain these tools from and roughly what sort of cost would be
involved?

Collectively we have experience of Ingres and of Oracle, but not of
migrating from one to the other.  I am aware of the Ingres unloaddb
utility for example.  Has anyone any experience of a similar migration
that could offer us any tips?

Many thanks,

L Jackson.


Re: Migration tools for moving IngresII 2.5 data and ABF to Oracle

Postby Kris Tonastik » Wed, 22 Apr 2009 01:04:13 GMT



yes, your migration will take 3x as long as you think it will ;-)


Re: Migration tools for moving IngresII 2.5 data and ABF to Oracle

Postby Roy Hann » Wed, 22 Apr 2009 01:17:47 GMT




Moving your database won't be that hard.  There's a myriad tools to do
that, more or less.  I'd expect that part to take on the order of days
at most.

Moving your apps is much more of a project.  Unless there is a very good
reason not to, you'd be quicker, cheaper, and less risky to just update
the infrastructure.  Even doing a radical-sounding upgrade like Ingres
6.4 and ABF on VAX/VMS to Ingres 2006 on Windows with ABF on
client PCs is really quite simple and quick (and we've got the
references to prove it).

So is the problem the stale DBMS and hardware, or is the problem that
you don't want to run ABF?

-- 
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
Go to  http://www.**--****.com/ 



Re: Migration tools for moving IngresII 2.5 data and ABF to Oracle

Postby OldSchool » Wed, 22 Apr 2009 01:33:55 GMT



Uh....you do realize that newer versions of ingres are "supported"
right?  And migration of the app to that would be straightforward.

As far as data, I guess its gonna depend on the underlying hardware,
of which you haven't spoken.  For example, you might run into "endian"
issues, but those can be mitigated by dumping in character format.


One might pose that to an Oracle newsgroup.  I doubt that you find
much here (except maybe converting *from* Oracle *to* ingres)


Such conversion projects are always costly, and generally more than
you expect.  I've very limited experience w/ oracle, but I would think
you would be looking at re-writing the app in its entirety, and that
process would take somebody fairly familiar w/ both products

Similar Threads:

1.[Info-Ingres] Migration tools for moving IngresII 2.5 data and ABF to Oracle

On Apr 20, 2009, at 11:32 AM,  XXXX@XXXXX.COM  wrote:

> We have some medium sized IngresII 2.5 databases with ABF
> applications, still running on Reliant UNIX 5.43.  We need to migrate
> to some supported software on modern hardware, such as Oracle on
> AIX.
>
> Is anyone aware of migration tools to achieve this ...

If you were asking for help in migrating to a current version
of Ingres on modern hardware, you might get some love here;
but I personally don't have a lot of interest in helping
people migrate away from Ingres!  Have you tried an Oracle
forum?

Karl

2.[Info-Ingres] Migration tools for moving IngresII 2.5 data and ABF to Oracle

3.Migration options Forms 4.x with 2.5 triggers

Hi,

At present we're rolling out a new system but need to retain a legacy
sub-system (possibly for 2.5 years from now). Just wondering does
anyone have experience with the configuration below or suggestions
with the migration of such a system?
 
                       TIA,
 
                                    Michael.
 
 
	    Oracle database 8.1.7.4.1
            Oracle forms 4.x (some have v2.5 triggers)
            Platform: VMS

4.IngresII 2.5 on Reliant UNIX unresponsive until forcibly re-started

Here's an interesting Ingres puzzle for you.

We are running an IngresII 2.5 installation and an IngresII 2.0
installation on the same Reliant UNIX 5.43 server.  The older software
is hardly used and has not had any problems.

Our IngresII 2.5 main production installation became unresponsive to
all Ingres commands during a large batch job.  That job was in the
"sysmod" phase ("Modifying 'iiatribute'").

All the normal processes were running, but not using any CPU resource.
There were no useful error messages in any log file (errlog.log.
iiacp.log, iircp.log, DBMS logs, the batch process log).

The E_DM9043_LOCK_TIMEOUT messages in the error log and DBMS log look
like a symptom rather than a cause.  "CS_check_dead" in one of the DBMS
logs is a symptom of killing the DBMS server processes, isn't it?

When I killed processes and re-started the installation it worked fine.
 I also re-started the IngresII 2.0 installation (even though it
remained perfectly usable) in order to clean up any shared resources
left behind.

I have naturally searched for similar problems on the web, but without
a specific error message this is difficult!

Has anyone experienced anything similar?

Has anyone any suggestions as to where I might find some evidence?

Many thanks, L Jackson.

5.Migration from Ingres 6.4 and ABF

6. Missing a good db migration/db move tool

7. Tools for moving data from mySQL to Oracle

8. [Info-Ingres] Data migration from Oracle 9i/10g XE to Ingres 2006 R2



Return to DATABASE

 

Who is online

Users browsing this forum: No registered users and 60 guest