[SL] New start (is the following method save ?)

[Luc v. S. <lu...@co...>]

Hello Sql-ledgerers,

I have copied the database of a environment where I need to start all 
over again (after 3 months). But I want to keep some information (like 
parts, customers suppliers, ledger etc)

I have experimented a bit and I think the following works:

-*Copy database*
-*Delete the content of all the of the following tables: *acc_trans, ap, 
ar, assembly, audittrail, business, dpt_trans, exchangerate, 
exchangerate, gifi (Does not apply in my country), gl, inventory, 
invoice, JCitems, oe, orderitems, partstax ( I will need to redo this 
because of mistakes), Status, Yearend

-*The following tables I Kept intact:* Chart, customer,customertax, 
defaults ( I know i need t alter a few things there when I will start), 
department, employee, language, makemodel, parts, partscustomer, 
partsgroup, pricegroup, project(was empty), recurring (was empty), 
Recurringemail (was empty), Recurringeprint (was empty), shipto (was 
empty),  sic (was empty), tax, translation, vendor, vendortax, warehouse,


 From this I want start all over again (not so much need to be entered),

    * Orderentries,
    * salesbookings
    * financialbookings etc


I have been playing around a bit and it seems it will work, can anybody 
comment on this exercise before I start putting in my orders, sales, 
bookings etcetera. It is allways very painfull to find out you have done 
things wrong

Tanks in advance

Luc