Friday, June 27, 2014

How Do I - Series for NAV 2013 R2 Updated...

Hi all,

Microsoft have updated new videos on HOW DO I Series for NAV 2013 R2. Below are the link for new videos available on MSDN.

Thanks Microsoft MVP's for the HDI Series.

IF you are looking for Previously Released HDI Series Videos Please Refer Below Links.

>> From 01 To 26 Videos.     

>> From 27 To  42 Videos.

Below are the Links for New Videos.

Thursday, June 26, 2014

NAV 2013 R2 - How to Restore Selected companies With Multi Tenancy - Powershell (Using Direct Database & Service Tier).

Hi all,

In this post we will list down the steps to restore backup taken in Previous Post using power shell Using Direct Database & Service Instance For a MultiTenant Database.

If you haven't read the Previous post, please refer to Index of Posts.

UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution.

Below is the Details of my Companies in Each Tenant -



Monday, June 23, 2014

NAV 2013 R2 - How to Backup Selected companies With Multi-Tenancy - Powershell (Using Direct Database & Service Tier)

Hi all,

In this post we will list down the steps to take backup using power shell Using Direct Database & Service Instance For a MultiTenant Database.

UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution.

If you haven't read the Previous post, please refer to Index of Posts.

Below is the Details of my MultiTenant Service -



Saturday, June 21, 2014

NAV 2013 R2 - How to Restore a Selected companies - Windows/Web Client.

Hi all,

In this post we will list down the steps to Restore backup using Windows Client.
* Steps Remain Same for Web Client.

UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution.

If you haven't read the Previous post, please refer to Index of Posts.

Pre-Requisites -

To export or import data from a Microsoft Dynamics NAV database, you must be a user in the Microsoft Dynamics NAV database, and your user account must have a permission set that enables you to export or import data, such as the SUPER permission set.


Friday, June 20, 2014

NAV 2013 R2 - How to Restore Selected companies - Powershell (Using Service Tier)

Hi all,

As discussed in earlier post, we will see how to take Restore backup in a new database. In this post we will list down the steps to restore the backup taken using powershell service commandlet.

UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution.

If you haven't read the Previous post, please refer Index Post here.

Let's check the Content of Backup Taken Via Emport-NavData.

Microsoft have provided a Commandlet for the same i.e  Get-NAVDataFile.
This Commandlet takes file Location and Name as parameter and returns the details of Content of the backup File.

Open Powershell and Let's check the two file content using Get-NAVDataFile =
--------------------------------------------------------------
Get-NAVDataFile -FileName "c:\Two_Comapniesbackup_Service.navdata"
---------------------------------------------------------------


So its clear from the Result of Commandlet that the above file contain 2 Companies with IncludeApplicationData only.

Thursday, June 19, 2014

NAV 2013 R2 - How to Restore Selected companies - Powershell (Using SQL Database).

Hi all,

As discussed in earlier post, we will see how to take Restore backup in a new database. In this post we will list down the steps to restore the backup taken using Powershell.

UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution.

If you haven't read the Previous post, please refer Index Post here.

From the Task Performed in Earlier Posts Backup From Powershell, i have below files as shown Below -



Wednesday, June 18, 2014

NAV 2013 R2 - How to Backup Selected companies - Windows / Web Client.

Hi all,

In this post we will list down the steps to take backup using Windows Client.
* Steps Remain Same for Web Client.

UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution.

If you haven't read the Previous post, please refer to Index of Posts.

Pre-Requisites -

To export or import data from a Microsoft Dynamics NAV database, you must be a user in the Microsoft Dynamics NAV database, and your user account must have a permission set that enables you to export or import data, such as the SUPER permission set.


NAV 2013 R2 - How to Backup Selected companies - Powershell (Using Service Tier).

Hi all,

In this post we will list down the steps to take backup using power shell & Service Instance.

If you haven't read the Previous post, please refer to Index of Posts.

We will see usage of below listed 3 & 4 Commandlet options in this post.

3. UseNST_AllCompanies
4. UseNST_SomeCompanies

Let's see how to use each of them.

Tuesday, June 17, 2014

NAV 2013 R2 - How to Backup Selected companies - Powershell (Using SQL Database).

Hi all,

As discussed in earlier post, we will see how to take navision backup similar to .fbk file and restore it in a new database. In this post we will list down the steps to take backup using power-shell.

If you haven't read the Previous post, please refer here.

UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution.

Hope till now you have uninstalled the older build of NAV 2013 R2 and installed the latest Build i.e 7.1.3687 as shown below.



For Demo Purpose i have a created 4 companies in a database as shown below, where A & B are copy of Cronus international whereas C is a blank company.



NAV 2013 R2 - How to Backup and Restore Selected companies CONCEPT.

Hi all,

The most awaited feature in NAV 2013 R2 by most of the consultants around the globe have been finally come as a work around. All Thanks to Microsoft Product Team.

In this post we will see the various ways of taking the Backup of the Database available in NAV 2013 R2 and in subsequent posts we will see how to take backup using Powershell and Windows Client.

** The NAV 2013 R2 Should Have the Build 7.1.36987.
** Uninstall the Previous Version of NAV 2013 R2 and install the latest build.

UPDATE - IF you face issues of Schema During This Process Please refer the Post Here for Issue Resolution.

Post in this series -

1. The Concept (This Post).

Without Tenants -
2.   Backup Using Direct Connection to Database.            
3.   Backup Using Service Tier.                                        
4.   Backup Using Windows Client.                                  
5.   Restore Using Direct Connection to Database.          
6.   Restore Using Service Tier.                                      
7.   Restore Using Windows Client.                                

With Tenants - 

Monday, June 16, 2014

NAV 2013 & NAV 2013 R2 - How to - Use OData to Return or Obtain a Service Metadata

Hi all,

In Previous post related to ODATA we saw how to publish and consume a ODATA Web Services from NAV 2013 & 2013 R2.

Below are some link Related to Old Articles Published for ODATA -

NAV RTC - Introduction to Web Services.

Introduction of ODATA Services In NAV 2013.

What is the ODATA?

Max. Page Size in ODATA Parameter.

Consuming Output of ODATA - Part 1


Today we will see a small but important point about ODATA i.e How we can see Metadata of Odata Web Service we have exposed.

Saturday, June 14, 2014

NAV 2013 R2 - Cumulative update 8 Released.

Hi all,

Please find below the details of Update Rollup Cumulative Update 8 released for Microsoft Dynamics NAV 2013 R2.

Title - Cumulative Update 8 for Microsoft Dynamics NAV 2013 R2
Build No. - 36897
Release Date - June, 2014
Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU

Download Link

Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.


Friday, June 13, 2014

NAV 2013 - cumulative update 15 Released.

Hi all,

Please find below the details of Cumulative Update 15 released for Microsoft Dynamics NAV 2013.

Title - Update Rollup 15 for Microsoft Dynamics NAV 2013
Build No. - 36919
Release Date - June, 2014
Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK

Download Link

For information about previous Update Rollup released for Microsoft Dynamics NAV 2013 below are the links -

Wednesday, June 4, 2014

NAV 2013 R2 - Restore a Multi Tenant Environment.

Hi all,

We had seen how to create a Multi Tenant Environment & How to Backup the Complete Environment with NAV 2013 R2 in the respective articles.

But what if i want to do a restore backup of the Multi Tenant Environment in a Different Server. How can i achieve it as in my SQL now i have multiple databases.

So let's see how we can achieve it.

** References - Waldo Blog. Thanks to Waldo for sharing the Information, i have tried to append the steps listed in the Video.

Scenario -
I took backup of My Multi tenant Environment Created with Multiple Tenants (5) and Application Objects. I want to Restore the whole Environment and Restore it on New Server.

Tuesday, June 3, 2014

NAV 2013 R2 - HowTo Backup a Multi Tenant Environment?

Hi all,

We had seen how to create a Multi Tenant Environment with NAV 2013 R2 earlier.

But what if i want to do a backup of the Multi Tenant Environment and Restore it on a Different Server. How can i achieve it as in my SQL now i have multiple databases.

So let's see how we can achieve it.

** References - Waldo Blog. Thanks to Waldo for sharing the Information, i have tried to append the steps listed in the Video.

Scenario -
I have a Multi tenant Environment Created with Multiple Tenants (5) and Application Objects. I want to Backup the whole Environment and Restore it on New Server.