@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
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
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
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
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
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
: 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
7 matches
Mail list logo