Bill,
If you must have an .arx file you could use the runmacro.exe command. It is not especially fast, but much better than the WUT and you can start it and let it run while you do something else (like sleep). You can include queries with it to filter records as necessary and you can create a batch file that will perform multiple exports with a single command. The docs for the command are in the "Integrating with Plug-ins and Third-Party Products" document. Roger Medsker Remedy Consultant Bluestem Consulting Group, LLC roger.meds...@bluestemcg.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of William Rentfrow Sent: Thursday, November 12, 2009 9:27 PM To: arslist@ARSLIST.ORG Subject: Re: Need to export 12,000,000 or so records... ** This is not an option unfortunately. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 _____ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tommy Morris Sent: Thursday, November 12, 2009 3:55 PM To: arslist@ARSLIST.ORG Subject: Re: Need to export 12,000,000 or so records... ** Can you just use AIE from 7.x and pull the data directly from the 5.x database? Then stage it all out into separate jobs to reduce performance hit. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of William Rentfrow Sent: Thursday, November 12, 2009 3:51 PM To: arslist@ARSLIST.ORG Subject: Need to export 12,000,000 or so records... ** 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"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
