Re: Cleaning up forms before migration

2014-01-10 Thread Brian Goralczyk
@ARSLIST.ORG] *On Behalf Of *Cecil, Ken *Sent:* Thursday, January 09, 2014 2:58 PM *To:* arslist@ARSLIST.ORG *Subject:* Cleaning up forms before migration ** We have some backend forms with large amounts of data that we don’t care about and would like to delete before doing a data migration

Re: Cleaning up forms before migration

2014-01-09 Thread Roger Justice
Truncate the table at the DB level is the most efficient way since you do not need to keep any of the data. -Original Message- From: Cecil, Ken kce...@hubbell.com To: arslist arslist@ARSLIST.ORG Sent: Thu, Jan 9, 2014 3:58 pm Subject: Cleaning up forms before migration ** We have

Cleaning up forms before migration

2014-01-09 Thread Cecil, Ken
We have some backend forms with large amounts of data that we don't care about and would like to delete before doing a data migration. For example FB:History has over 160 million records. What is the best way to go about deleting data out of the forms that have gotten away from us. I know we

Re: Cleaning up forms before migration

2014-01-09 Thread Grooms, Frederick W
Sent: Thursday, January 09, 2014 2:58 PM To: arslist@ARSLIST.ORG Subject: Cleaning up forms before migration ** We have some backend forms with large amounts of data that we don't care about and would like to delete before doing a data migration. For example FB:History has over 160 million records

Re: Cleaning up forms before migration

2014-01-09 Thread Charlie Lotridge
in question and Truncate the T, H, and B tables for that ID Fred *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Cecil, Ken *Sent:* Thursday, January 09, 2014 2:58 PM *To:* arslist@ARSLIST.ORG *Subject:* Cleaning up forms before

Re: Cleaning up forms before migration

2014-01-09 Thread pritch
to be carefully constructed. - Original Message - From: Charlie Lotridge lotri...@mcs-sf.com To: arslist@ARSLIST.ORG Sent: Thursday, January 9, 2014 4:12:38 PM Subject: Re: Cleaning up forms before migration ** Assuming you're planning to delete ALL the data in each of these forms, I agree

Re: Cleaning up forms before migration

2014-01-09 Thread Cecil, Ken
: Cleaning up forms before migration I sometimes put the 'direct sql' into an escalation. Schedule it to run either once, or on a periodic basis to continue to keep things trimmed down. For instance, a weekly escalation that deletes records that are more than xx days or weeks old. As mentioned