Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: data migration
> The sqlloader approach involves writing a script to dump the data and
> generate the sqlloader control files, while the MS-Access approach
> involves setting up an sql statement ("insert into oracle.table as
> select * from ingres.table") for each table and identifying primary keys
> as each table is linked into MS-Access. We have about 200 tables.
>
> I would love to hear what other people have done or what tools, if any,
> address this problem.
>
My company provides a suite of software and services that ease the process of data migration. We use a dictionary based approach for describing the meta data and the mappings between the legacy and the new system. The product generates PERL source to actually perform the conversion, so the human/error prone side is eliminated. The tools integrate tightly with ERWIN. If you're trying to support a migration with a large number of tables, or the transformations between the two systems aren't simple, then you'll definately be interested in what we have to offer.
Please visit our web site at http://www.metagenix.com
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 30 1998 - 00:00:00 CDT