Unfortunately...no DSO :) William Rentfrow Principal Consultant, StrataCom Inc. [email protected] O 715-592-5185 C 715-410-8056
________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Doug Blair Sent: Thursday, November 12, 2009 7:35 PM To: [email protected] Subject: Re: Need to export 12,000,000 or so records... ** 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. [email protected] O 715-592-5185 C 715-410-8056 _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ Doug -- Doug Blair [email protected] +1 224-558-5462 200 North Arlington Heights Road Arlington Heights, Illinois 60004 _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"
<<bmc_skilled_pro_ar.png>>
