Script to clean up a database?

JTPro · 2006-07-13

Hello all,

My employer wants me to write a script that will clean up whole database. They have already posted a lot of documents and made a lot of modification. They want to keep all setting and modifications, but delete all posted documents. Is it possible? Maybe someone has already written such script.

Need your help.

Best regards
JTPro

DenSter · 2006-07-13

Is that legal in Poland? Can you just delete all posted information from your financial system?

Or are you talking about cleaning up a test system?

ara3n · 2006-07-13

standard navision has such thing it's If you go to setupchecklist. |THen click on Function->Implementation. On data cleaning tab you'll a button for clean. This wil clean al the transaction data. Afterwards check the table that still have records. File->database->info->tables. Find the ones that have still records and write a report to delete those.

Alex_Chow · 2006-07-13

Or you can use use the Date Compression function in Navision.

garak · 2006-07-13

If you realy want to clear all Tables, take a look undet File \ Database \ Information \ Tables here you can see all tables with entries. Now you can write an report which delete all Records in that tables you are must clear.

if you will not add evry table as variable use recref.

andrejsm · 2006-07-13

Hi,
You need to carefuly analyze which tables to clean up. Because ussually we don't want to delete setups and data which could be reused (customer, vendor cards e.c.)
You can use Function from Setupchecklist, but be careful, this function have some issues. Some tables still have transactions data. If I remember correctly one of these tables are bank accounts ledger entries.
Our company write special code unit for cleaning purposes. It is very useful after user trainings to delete transaction information, but still have all setups

Miklos_Hollender · 2006-07-13

JTPro,

this is why I written this:

http://mibuso.com/dlinfo.asp?FileID=580

With this tool you gotta look at each table, press Ctrl+L and decide whether it should be deleted or not.

It's about 2 hours (I tested it). But at least in this two hours you will get a profoung knowledge of Navi table structure

JTPro · 2006-07-14

Thanks a lot guys.

Im really apprieciate.

The database is a test one, so there is no stress.

Best regards

JTPro

Script to clean up a database?

Comments

Categories