Saurav Dhyani - #MSDynNAV & #MSDyn365bc

Hi All, While Browsing Partner Source and Microsoft Team Blog i found out some interesting link and thought of sharing them. Below are some updates from Microsoft on Team Blog -

Hi all, Below is a detailed post from one of the article listed in Microsoft Team blog about "Introducing the Microsoft Dynamics NAV Application Pro filer". With the tool, we can monitor how your application code performs at real time? You can also consider it as advanced version of old Client Monitor. Let's see how to install and configure the tool and use this tool to enable C/AL code tracing and determine application performance during code execution. Download = 1. Download the Dynamics NAV Application Profiler From CodPlex

HI all, While Reading a article on Mibuso i see a simple requirement i.e to change the Start UP Screen of Navision Role Tailored Client. The Post below in not related to any Navision Feature or Functionality, but if you want to read it let's scroll Down.

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 How to Use OData to Return OR Obtain a Service Metadata (EDMX) Document How to - Use OData to Return OR Obtain a JSON Document Today we will see how to Using Filter Expressions in OData URIs. To add a filter to an OData URI, add $filter= to the end of the name of the published web service.

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 How to Use OData to Return OR Obtain a Service Metadata (EDMX) Document Today we will see how to Return / Obtain a JSON Document. What is JSON?

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.

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 -

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 -

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.

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 fi

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 -

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.

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.

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.

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 .      

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.

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.

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.

Hi all, This post is based on suggestion from  +Ami Paneri Upadhyay * The Screen Shots and Query Applies - TO NAV 2013 R2. Steps Remain Same for NAV 2013 but query will get change. * The Query for NAV 2013 can be found in my Skydrive, Link at the end of the post. Let's see what was required and how we can achieve it. CASE - I received a database from customer and my windows login is not there in the database. I don't want to delete Customer Users from the database but want to add myself in the Users. How can we do this? OR We have a database internally for development. All the consultants having User ID's in the database are not available. I want to access the database, How can i achieve it? If you are using NAV 2013 R2 or Higher Please refer this article.

Hi all, As discussed and Found the Cause of Issue related to Dimension During Upgrade, Lets' see how to Resolve Same Before Upgrading or During Step 2. If you haven't Read the Earlier Post Use The Link. NAV 2013 & NAV 2013 R2 - Common Issue Related to Dimension in Step 2  There are two points which make our life Easy - 1. In Earlier Version i.e 2009 / 2009 SP1 / 2009 R2, the Dimension Values were used to Store in a separate Table. 2. The Upgrade Step Batch Job Commits the Transaction Before the Error Occurs, i.e If Table X have Issue in Data Everything done before Table X is Committed.