Here is what i want to do
- I have created a database and i want to use it for testing so to this effect, many transactions and product movement will occur within the database. However, I wish to use this same database as a production(live database).
- I want to know if it is possible to clear all transactions and activities within the database without having to uninstall and re-install the modules in which they occur because the modules have custom fields and menus that took alot of time to build and develop
I wish this to be done without having to duplicate the database as this is not currently possible.
Please is this possible and how do I go about it?
hhhhmmmm i usually access the database through pgadmin or psql and delete the related transaction manually using query but you need to take a note you should do it carefully and you need to understand the flow this method is not recommended