Feature Pack? What's Likely?

journal archive tool:

1. backup your existing database.
2. delete old journal entries with sql command like - delete from journal where time < '1/1/2009'
3. shrink database with sql command - dbcc shrinkdatabase ('databasename',

1. probably should reindex again - dbcc dbreindex ('journal')

Matt,

That won't archive anything, it just deletes them.

Tim,

Retail Realm has a database archiving utility add-on that will do what you want easily. I know it's not what you asked for, you want it built in, but if you truly do need it right now, it's there.

Right, the point is that your backup in step 1 becomes your archive. You can then restore it into a different database name and use it as a static copy of everything up to that point and delete anything else out of the current database that you don't need. Journal entries are a safe one to delete because they take the most space and are not as important.

Make sure not to delete any AccountReceivable info as past records are used to calculate current balances.

Also beware of what kind of reports you run that might need to include past history in the same database to get the right totals. For instance, I sometimes compare the Item Movement History report summary of an item against current inventory level to find balance discrepancies, but that would be harder to do if the history were split between different databases.

Other tables that I like to purge are: RecordDeletedLog InventoryTransferLog PurchaseOrderEntryDetail PurchaseOrderEntry PurchaseOrder QuoteTenderEntry OrderHistory OrderEntry Order Shipping VoucherEntry TaxEntry TransactionEntry Transaction NonTenderTransaction Payment DropPayout TenderEntry OldJournal Batch DailySales TimeCard TimeStampLog HQ_EventLog HQRecordDeletedLog Worksheet_DelGlobalCustomers Worksheet_GlobalAccountAdjustment Worksheet_InventoryTransfer Worksheet_ItemCost Worksheet_ItemPrice Worksheet_ItemPriceLevel Worksheet_ItemPriceLimit Worksheet_ItemQuantity Worksheet_ItemRestock Worksheet_ItemTax Worksheet_ItemUpdate Worksheet_PurchaseOrder Worksheet_SQL Worksheet_SupplierList Worksheet_SupplierUpdate WorksheetHeader_PurchaseOrder WorksheetHistory WorksheetStore Worksheet

Please speculate as to what enhancements or changes might appear in the upcoming feature pack.

I am wishing for a journal archiving feature so that I can shrink my database size.

I am also wishing for local caching of "Check Stores" data, so that every inventory check doesn't need to poll HQ.

I am also wishing for something pretty darn impressive given the maintenance fees that were just paid!

Please speculate as to what enhancements or changes might appear in the upcoming feature pack.

I am wishing for a journal archiving feature so that I can shrink my database size.

I am also wishing for local caching of "Check Stores" data, so that every inventory check doesn't need to poll HQ.

I am also wishing for something pretty darn impressive given the maintenance fees that were just paid!

Please speculate as to what enhancements or changes might appear in the upcoming feature pack.

I am wishing for a journal archiving feature so that I can shrink my database size.

I am also wishing for local caching of "Check Stores" data, so that every inventory check doesn't need to poll HQ.

I am also wishing for something pretty darn impressive given the maintenance fees that were just paid!