Re: Migrating from Access to Oracle

From: noyfb <noyfb_at_kma.com>
Date: Mon, 16 Aug 1999 11:13:03 -0700
Message-ID: <muYt3.3661$lk5.4287@client>

On Question
4. Sequences & Triggers are created for Autonumber fields in the migration tool.

I don't know about 2000 but I am still using 97 for the front end and have found using Sequences & Triggers that act on primary keys, very problematic. Records get added but do not show up untill the Recordset is Refreshed.

Gary Topp

James F. Hurff wrote in message ...
>I have a couple of questions on this topic. I would greatly appreciate any
>assistance:
>
>1. Is the Access conversion utility still available to download from
>Oracle...I cannot seem to find it on the Free/Trial Software download page
>where it used to be?
>2. Is the utility compatible with Access 2000 or do I need to export the
>Access database to a Access 97 format?
>3. If the cascade update/delete is enabled in the Access design, are
>associated triggers created on the Oracle side?
>4. If the Autonumber datatype is used in the Access design, are associated
>sequences created on the Oracle side?
>5. Are the entity relationships passed from Access to Oracle?
>
>Thanks in advance.
>
Received on Mon Aug 16 1999 - 13:13:03 CDT