Database – Page 5 – Pardaan.com

NAV 2013 R2: How to Back up a Live Database and Refresh a Test Database

If you have a test database, at some point in time you will be asked to refresh this with the current live data, especially when testing. I am often asked how to copy the live database into the test database so accurate testing of a development…

12 October 2015

Dynamics NAV & BC Tips & tricks

Database Schema Synchronization

Microsoft Dynamics NAV 2015 introduces several improvements to the table schema synchronization process that improve performance and make it more explicit and controllable. The improvements give you with the flexibility to decide when and how the table changes are synchronized with corresponding tables in the SQL…

2 September 2015

Dynamics NAV & BC Tips & tricks

Database function

EXPORTDATA Function (Database) Exports data from the Microsoft Dynamics NAV database to a file. The data is not deleted from the database. Syntax [Ok:=] EXPORTDATA(ShowDialog, FileName[, IncludeApplicationData][, IncludeGlobalData][, CompanyRecord]) Parameters ShowDialog Type: Boolean Specifies if you want to display a dialog box where the user can…

31 August 2015

Dynamics NAV & BC Tips & tricks

How to Back Up and Restore a Dynamics NAV 2015 Database Using SQL and PowerShell

Several weeks before our customer’s go-live of Microsoft Dynamics NAV 2015, users were vigorously testing NAV as we were ironing out the specifics of the customer’s desired configurations. During this process, we wanted to start with a clean testing environment (where we wanted to use the…

17 August 2015

Dynamics NAV & BC Tips & tricks

Script Search for a string in “all tables” of SQL Server Database

Good & Fast Script to search for a string in “all tables” of SQL Server Database, very useful with NAV Databases too (to find data FAST in each database\company, no C/AL Code or powershell commands required ) Bron : Roberto Stefanetti NAV Blog Lees meer...

11 August 2015

Dynamics NAV & BC Tips & tricks

Building a clean database – remove not licensed objects

I just got a question from a client; Gunnar, Do you have a “King Kong” license that will allow you to delete any object? It appears our development license does not have the rights to some of the newer LS Retail objects and I need to…

23 July 2015

Dynamics NAV & BC Tips & tricks

Key impact on database size

I am not sure about the article that i am writing that i Should Write it or not. The area that i am about to discuss is something where i am a newbie and would like to explore the area. The Reason behind article was something…

13 July 2015