kriki: Clean up NAV2013 security and settings tables

[Blog bot]

When you prepare a database in the company and are then ready to backup/restore it at the customers, you probably have some info in it that is not really useful like users, some settings saved by those users, debugger breakpoints, session event info.

Here is a small TSQL script to clean just that:

 

USE [YourNAVDatabase];

delete FROM [dbo].[Access Control];

delete FROM [dbo].[User];

delete FROM [dbo].[User Property];

delete from dbo.[User Personalization];

delete from dbo.[User Metadata];

delete from dbo.[Page Data Personalization];

/* You can also run these if you want.

delete from dbo.[Debugger Breakpoint];

delete from dbo.[Session Event]; — not really needed. Is deleted automatically after a while by the server.

*/



Читать дальше