Re: Migrating from Access to Oracle

From: Arvin Meyer <a_at_m.com>
Date: Tue, 6 Jul 1999 13:53:01 -0400
Message-ID: <7ltfl4$4qv$1@nntp8.atl.mindspring.net>

How can you get an unbiased source when you've only asked Oracle newsgroups, post the same question in SQL-Server newsgroups and the answer will be quite different.

I am an Access/SQL-Server developer so I'll give you my viewpoint. I'd use Access, without reservation, for anything up to 10 users and 100 MB of data, on a fast Ethernet system. I'd use SQL-Server, without reservation, for anything up to 500 users and 500 GB of data. I'd think about Oracle ONLY if I needed greater capacity than that. My reasoning is solely based on cost/benefit analysis of all 3 systems. Obviously, if you feel more comfortable with Oracle than SQL-Server, you should use it. ---
Arvin Meyer

CMG wrote in message <378224A0.84B5980C_at_pobox.com>...
>Greetings -
>
>Our business is built on Access 2, but time to move to SQL Server, or
>preferrably, Oracle, retaining Access as the front end. We'll upsize to
>Acc97, then migrate to Oracle, if it really works.
>
>Has anyone tried such a migration? What was your experience? Any input
>or
>links you can provide would be greatly appreciated. I do have the Oracle
>Migration Tools, but I much rather hear the truth about migration from
>an unbiased source.
>
>Thanks,
>Adam Kahn
>
Received on Tue Jul 06 1999 - 12:53:01 CDT