Database cleanup

Mar 26, 2010 2 Replies
P

Hi all,



I have have RMS 1.2 running under SQL 2000. I want to erase all data except the following:



1) Item lookup code
2) Description
3) Available quantity
4) Price
5) Customers
6) Register List
7) Sales Taxes
8) Cashiers
9) Department & Category List
10) Tender Types
11) Suppliers

I basically want to start out fresh with the exception of the above list.



Any help on this would be greatly appreciated


Vote
Twitter Facebook LinkedIn
M

here is my archive script which might help. Make sure to get a backup first!

DELETE from RecordDeletedLog where WhenDeleted < '01/01/2010' DELETE from InventoryTransferLog where DateTransferred < '01/01/2010' DELETE from PurchaseOrderEntryDetail where Date < '01/01/2010' DELETE POE FROM PurchaseOrderEntry POE LEFT JOIN PurchaseOrder PO ON POE.PurchaseOrderID=PO.ID AND POE.StoreID=PO.StoreID WHERE PO.DateCreated

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required