locked
Remove transaction records RRS feed

  • Question

  • Hi there,

    We intend to use the MDS transaction log to determine the number of members that are created/updated/de-activated by our automated data feed each day.

    As this table is likely to grow very large, we are considering automatically moving older transaction records to another database to minimise the growth of the MDS database.  Is it possible to remove transaction records from tblTransaction without impact to MDS?

    Thanks,

    Michael
    Wednesday, August 18, 2010 3:55 AM

Answers

  • You could create (copy) a new version.  Prior transactions will be associated with the old version.  The old version, along with its transactions, may be deleted via API call (MetadataDelete).

    Friday, August 20, 2010 12:29 AM