If all you need is to take over table data and structure then DTS can do
that providing you have the drivers for Oracle. As for creating the indexes
etc well that will be a manual process, I know of no "Upsizing" tool from
Access to Oracle.
--
----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"James Li" <james.li (AT) aspentech (DOT) com> wrote
Quote:
How can an Access database or SQL database be converted to
Oracle? In my case, I need to import tables in Access and
SQL to Oracle. Thanks.
|
Re: Convert Access/SQL to Oracle -
08-15-2003
, 01:01 AM
Linear Mode
