Mike:
Correct. I would start with about 50K records and adjust up and down. Also, I would disable any workflow that fires on merge until the cutover is completed.
James Mckenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Mike White
Sent: Thursday, July 20, 2006 10:04 AM
To: [email protected]
Subject: Re: Upgrading Remedy - 4.5 to 6
Jim,
By "chunk out", you mean export large tables in separate "batches" - xx records at a time, then import each .ARX individually, right?
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
"McKenzie, James J
C-E LCMC To: [email protected]
HQISEC/L3" cc:
<[EMAIL PROTECTED] Subject: Re: Upgrading Remedy - 4.5 to 6
S.ARMY.MIL>
Sent by: "Action
Request System
discussion
list(ARSList)"
<[EMAIL PROTECTED]
RG>
07/20/2006 12:32
Please respond to
arslist
**
Shawn:
Chunk out the data for the large forms. This should eliminate the timeout error.
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [ mailto:[email protected]] On Behalf Of Shawn Stonequist
Sent: Thursday, July 20, 2006 9:29 AM
To: [email protected]
Subject: Upgrading Remedy - 4.5 to 6
Greetings List!
We are currently working on upgrading our Remedy from 4.5 to 6 (woo hoo!) and have new servers, databases, etc. that we will be using.
In the past when we've migrated/moved our Remedy, we have moved the data by exporting it through the User Client (our largest form was only 45k entries, followed by a 25k entry form). Today however, we have at least a dozen forms with 60k+ (several with 200k+) and are encountering timeouts and other performance issues when trying to export the data to be moved.
The last time we tried moving the data from one DB to the new DB, it all but blew up.
We are wondering if anyone else has had to move (what we consider) large amounts of data and knows of a more efficient way to do this.
Thank you VERY much in advance for your assistance!
Shawn Stonequist
EMNS, Inc.
Remedy 4.5
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
