Re: Need to export 12,000,000 or so records...

[Doug Blair]

** Bill, Is DSO available?  That will work across server versions, allow some field mapping, and (the reason I like it) allow you to keep the data current as the old server is updated before your cutover.  Don't do it all in one batch, of course.... if you can log into both servers from the same user tool you could write some workflow which would copy them one at a time too. Fast, no. Cheap, yes.... Doug On Nov 12, 2009, at 3:50 PM, William Rentfrow 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. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ Doug -- Doug Blair d...@blairing.com +1 224-558-5462 200 North Arlington Heights Road Arlington Heights, Illinois 60004 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_