On Mon, Jun 27, 2011 at 11:02 PM, Chris Travers <[email protected]> wrote: > On Mon, Jun 27, 2011 at 10:02 PM, david <[email protected]> wrote: >> I want to clone a database but with no financial transactions. I want to >> keep customers, vendors, parts, services, accounts, etc. but all >> accounts with zero balance. >> >> Is this possible? >> > Yes. In psql: > > CREATE DATABASE my_newdb WITH TEMPLATE my_old_db; >
Note this will clone everything. If you want to get rid of the transactions, you will need to delete everything in the acc_trans, ar, ap, and gl tables. ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
