Re: Upgrade from MS Access?

From: Van Nieuwenhuyse <van_nieuwenhuyse_luytens_at_online.be>
Date: Sat, 6 Feb 1999 17:23:48 -0500
Message-ID: <F4155D9F9AA4D111B9990020AFBA52D50C5C6D_at_ftp.sfi-software.com>


[Quoted] On the Oracle8 cd there's standard a migration tool from access to oracle included;

Doug Roswold heeft geschreven in bericht <36BCA718.45C7D426_at_spacestar.net>...
>How difficult will it be to migrate from MS Access97 to Oracle?
>
>We're using a homebuilt MS Access97 database for customer information,
>order entry, equipment history, parts manufacturing information, price
>lists, quotations, purchasing and inventory. We have about 25 users and
>are about to outgrow our Novell 3.12 server. This Access database is
>very slow for several applications (a multilevel BOM can take up to 5
>minutes on some PC's!)
>
>Should I believe what Microsoft marketing when they try so hard to tell
>us that it's an easy upgrade to their SQL Server, just run their Access
>migration tool and your up and running on a much faster system?
>
>I'm not keen on switching to an NT server (the one I support for our
>firewall has caused me nothing but problems), so I'd like to stick with
>Novell. My Novell support guys tell me that Orcale is the natural
>choice if I stay with Novell for my next server.
>
>Are there migration tools available for upgrading from MS Access to
>Oracle?
>
>Are Oracle and MS SQL server similiar in the level of programming
>expertise that's required?
>
>Will maintaining an Oracle or MS SQL Server become a full-time job (I
>average about 2-4 hrs/week on maintaining Access)?
Received on Sat Feb 06 1999 - 23:23:48 CET

Original text of this message