Hi all, as part of our PCI policy we are planning to delete any aged credit card data from the Transcend database periodically. Does any of you have any SQL script to for this purpose that you can share? We could not find any built-in report in Transcend client to do this job. So before start digging into the Transcend database to write a new script thought I would first check if any of you have anything like this which we can use.
Advanced thanks for any help. Any suggestion, comment will be highly appreciated.
Mo
There actually is a standard sproc for that in the TPAU database, named P_ARCHIVE_TPAU_DATA. I'd recommend checking in with Intrix support before using it. Despite the name, you archiving the data is optional, simply purging is possible.
Also, note that it can run while CC processing is up and running, but at the expense of speed, i.e. it runs very slowly. All after noon the first time we ran it!