Re: Access-to-Oracle

Thanks Spark and Bricklen, but one more question...the download page says the migration tool is for 9i. Will it work with 8i?

Downloading as we speak... :-)

dan

"Spark" <nospam_at_hotmail.com> wrote in message news:<3c3adbe4$0$231$ed9e5944_at_reading.news.pipex.net>...
> Dan,
>
> I have used the utility on anumber of occassions. I have found it straight
> forward and logical. I would recommend it.
> "Bricklen Anderson" <bricklen_at_shaw.ca> wrote in message
> news:3C3A0DF7.5C9E58C7_at_shaw.ca...
> > you can download the migration workbench from
> > http://otn.oracle.com/software/tech/migration/workbench/content.html
> > or just go the download page at oracle's site, choose the right-hand
> > drop-down list and search through that one (the utilities and drivers
> > one).
> > Dan Barron wrote:
> > >
> > > A common question I'm sure, but here goes...
> > >
> > > I'm an experienced DBA who is using Oracle for the first time. I have
> > > a couple of Access databases to convert and was wondering what you all
> > > think is the best way to accomplish this. The databases are Access
> > > 2000 databases and my Oracle 8i version is 8.1.7.0.0.
> > >
> > > I read about a Migration Assistant, but it seemed limited Access 97
> > > plus I couldn't find it anywhere to download. Is the MA the best way?
> > > I could write an SQL script to create the tables, etc. and then export
> > > the data to text files and import, but that seems like a lot of work.
> > > I've tried the "Export" command in Access, but the results are not
> > > satisfactory (it seems very stupid about data types, for one thing.)
> > >
> > > Any help or pointers to information as to the best way to accomplish
> > > this would be much appreciated.
> > >
> > > dan
> > >
> > > Dan Barron
> > > ACP-ASIM
> > > dbarron_at_mail.acponline.org
Received on Tue Jan 08 2002 - 09:38:56 CST