With Extensions v2 in Microsoft Dynamics NAV2018, fields are distributed across multiple SQL tables. In the example here, I have added a tableextension object that adds the “KOB Nummer” field to the customer table.
Tag Archives: Database
How to Backup and Restore NAV Database Using SQL Server
Data is one of the most valuable assets of any company. To ensure you keep your data safe, database backups are essential.
After the release of NAV 2013 R2, Microsoft discontinued the NAV Database backup (.fbk) feature. An additional option was added to allow for import/export of data in NAV 2013 R2, but doing a backup using the Import/Export Data feature is time consuming.
Database Collations During Microsoft Dynamics NAV Upgrades
This blog post describes how collations might change during an upgrade from a Dynamics NAV 2009 database to Dynamics NAV 2013, why they change, and how to determine the destination collation.
Today’s guest blogger is Erik Hougaard (b|l|t). Erik is a Dynamics NAV MVP who describes himself like this:
Stored Procedures on a NAV database?
Recently, I came across a customer, where a partner had implemented some Stored Procedures on a Microsoft Dynamics NAV 2017 database.
Now, for any change on SQL level that comes to my ears, my first reaction is always “Nooooooooo“. Or as a pictures tells more than a thousand words:
Creating a new database in NAV 2017
Generally, when we install NAV, a default Demo database is always created in the Microsoft Dynamics NAV Development environment. In this blog, a new database is created thus, the developer can use two or more databases in a single NAV Development environment.
Dynamics NAV: Get Database Name for current installation
I started writing a couple blogs to determine, if the current installation is a multitenant installation or how to get the name of the current SQL Server. There are a few more useful things that you can do with the DLLS that are shipped with Dynamics NAV.
Moving a Dynamics NAV database with file groups to Azure
The short story: If you use SQL Server for your Dynamics NAV database, and if you are using multiple file groups (other than PRIMARY), as per SQL Server recommendations for better IO performance, and if you need to export the database to Azure, then you need to use the latest update.