I need to reduce my db size...
Many have posted about the Retail Realms archiving utility. This sounds like a great app, but since I'm somewhat familiar with the db schema in RMS and know SQL, I would like to attempt it on my own.
Has anyone tried removing sales history through SQL? What tables should be cleared, does anyone have a script that they use?
I understand that a backup should be made prior to any changes :)
Paul