If you can link the two databases, I would just create some pl/sql scripts to copy the data over. You can manipulate in the script or in the table. I would use a staging table so that way you don't impact the production data until you are ready to.
Of course, that does no good if you can't connect the databases. Brian On Thu, Nov 12, 2009 at 3:50 PM, William Rentfrow < [email protected]> wrote: > ** > > I have roughly 12,000,000 records I need to export to ARX format from CSS > 5.x to do a data migration to IM 7.03. > > The breakdown is roughly something like this: > > 3,000,000 archived SPRT:Issue records > 1,000,000 Person records > 6,000,000 Interaction records > 2,000,000 misc related records (active SPRT:Issue records, etc). > > Since I'd really prefer to NOT do this through the WUT in 100,000 segments > I'm throwing this out there for ideas. > > Changing the format this late in the game is a show-stopper. And we can't > use Migrator either. > > I have found one utility that is called "fast export" but there is no > documentation for it and I've found no way to get it to work. > > So….ideas? Thanks in advance…. > > William Rentfrow > Principal Consultant, StrataCom Inc. > [email protected] > O 715-592-5185 > C 715-410-8056 > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
