On Mon, Jun 27, 2011 at 11:05 PM, david <[email protected]> wrote: > > > Chris Travers wrote: >> 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. > > > Ahh.. that's the bit I was looking for. Do I do that with psql? > yes.
Best Wishes, Chris Travers ------------------------------------------------------------------------------ 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
