Database cleanup

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
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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<'01/01/2010' DELETE from PurchaseOrder where datecreated < '01/01/2010' DELETE QTE from QuoteTenderEntry QTE join [Order] O on QTE.OrderID=O.ID WHERE O.Time<'01/01/2010' DELETE OH FROM OrderHistory OH LEFT JOIN [Order] O ON (OH.OrderID = O.ID) AND (OH.StoreID = O.StoreID) WHERE (O.Time)<'01/01/2010' DELETE OE FROM OrderEntry OE LEFT JOIN [Order] O ON (OE.OrderID = O.ID) AND (OE.StoreID = O.StoreID) WHERE (O.Time)<'01/01/2010' DELETE from [order] where Time < '01/01/2010' DELETE S FROM Shipping S LEFT JOIN [Transaction] T ON S.TransactionNumber=T.TransactionNumber AND S.StoreID=T.StoreID WHERE T.Time<'01/01/2010' DELETE from VoucherEntry where Date < '01/01/2010' DELETE TE FROM TaxEntry TE LEFT JOIN [Transaction] T ON TE.TransactionNumber=T.TransactionNumber AND TE.StoreID=T.StoreID WHERE T.Time<'01/01/2010' DELETE TE FROM TransactionEntry TE LEFT JOIN [Transaction] T ON TE.TransactionNumber=T.TransactionNumber AND TE.StoreID=T.StoreID WHERE T.Time<'01/01/2010' DELETE from [Transaction] where Time < '01/01/2010' DELETE from NonTenderTransaction where Time < '01/01/2010' DELETE from Payment where Time < '01/01/2010' DELETE from DropPayout where Time < '01/01/2010' DELETE TE FROM TenderEntry TE LEFT JOIN [Transaction] T ON TE.TransactionNumber=T.TransactionNumber AND TE.StoreID=T.StoreID WHERE T.Time<'01/01/2010' DELETE from OldJournal where ClosingTime < '01/01/2010' DELETE from Journal where Time < '01/01/2010' DELETE from Batch where ClosingTime < '01/01/2010' DELETE from DailySales where Date < '01/01/2010' DELETE from TimeCard where TimeOut < '01/01/2010' DELETE from TimeStampLog where ServerTime < '01/01/2010' DELETE from HQRecordDeletedLog where WhenDeleted < '01/01/2010' DELETE W from Worksheet_DelGlobalCustomers W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_GlobalAccountAdjustment W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_InventoryTransfer W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_ItemCost W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_ItemPrice W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_ItemPriceLevel W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_ItemPriceLimit W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_ItemQuantity W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_ItemRestock W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_ItemTax W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_ItemUpdate W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_PurchaseOrder W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_SQL W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_SupplierList W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from Worksheet_SupplierUpdate W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from WorksheetHeader_PurchaseOrder W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from WorksheetHistory W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE W from WorksheetStore W JOIN Worksheet on W.WorksheetID=Worksheet.ID WHERE effectiveDate<'01/01/2010' DELETE from Worksheet WHERE effectiveDate<'01/01/2010' DELETE from HQ_EventLog WHERE eventtime<'01/01/2010'

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
You could also run the Delete Transactions from Administrator --> Database menu. Again make sure to do a backup first.
-- Robert Armstrong RMS Systems Inc. www.retail-pos.com
size=2 face=Arial>...<BR>&gt;&gt; Hi all,<BR>&gt;&gt;<BR>&gt;&gt; I have have RMS 1.2 running under SQL 2000. I want to erase all data <BR>&gt;&gt; except<BR>&gt;&gt; the following:<BR>&gt;&gt; 1) Item lookup = code<BR>&gt;&gt; 2) Description<BR>&gt;&gt; 3) Available quantity<BR>&gt;&gt; 4) Price<BR>&gt;&gt; 5) Customers<BR>&gt;&gt; 6) Register List<BR>&gt;&gt; 7) Sales Taxes<BR>&gt;&gt; 8) Cashiers<BR>&gt;&gt; 9) Department &amp; Category List<BR>&gt;&gt; 10) Tender Types<BR>&gt;&gt; 11) Suppliers<BR>&gt;&gt;<BR>&gt;&gt; I basically want to start out fresh with the exception of the above list.<BR>&gt;&gt;<BR>&gt;&gt; Any help on this would be greatly appreciated <BR>&gt; <BR>&gt;</FONT></BODY></HTML>
------=
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.