Hi All - Importing slightly less then 200,000 records from our current system into Remedy (ARS 7.0.01 patch 001, CMDB 2.0.1 patch 002, BMC Asset 7.0.02 patch 003, SQL Server 2003, Windows 2000 Server) from the command line (arimportcmd) using a private queue.
Due to the way the CMDB is structured, I'm importing to a form that has a number of display only fields, where I have workflow looking up the name of the form to import to (i.e. AST:ComputerSystem, AST:NetworkPort, etc.), then it pushes about 10 fields to the appropriate form. ARS Server and DB server are on separate boxes, so there is network to contend with as well. Within the limitations of what I've mentioned, does anyone have any thoughts on how to speed up the import? I thought about splitting the source file up, running it on several different private queues, but most of this particular import is going into one of two forms, so I'm not sure if that would help. Any advice from this experienced crowd? Thanks, Cindy _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
