I have been putting this task off for some time, but now I need to face it and go ahead and do it. The company I'm working for has been using GP since the days of 7.5. To my knowledge, it has never been purged of any of the old data. Within the last 2 weeks, we moved our infrastructure into a Data Center and and installed a fiber connection from the Data Center to the office. As I had figured, the users are starting to complain that the speed isn't there like it used to be, which is true, because they went from a local 100 mbps server connection to a 20 mbps fiber connection to the Data Center.
Trying to aid in the situation, one of the daunting tasks I'm thinking that would help is to purge the database of transactions beyond the 7 year retention period, which would hopefully decrease the size of the database and the amount of data being passed over the fiber pipe. That being said, I'm not quite sure how to go about purging the data while making sure that everything stays intact historically.
Also, to add to the list, we are running GP 9.0 SP1, which puts us, what, about 12 SP's behind.
So, my questions are: How do I go about purging the old data and then bring GP current? We also are running Wennsoft as a 3rd party add on.
Thanks in advance.
Jeff
*This post is locked for comments