SQL – Page 12 – Pardaan.com

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

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. Bron : Saurav Dhyani Lees meer...

26 June 2014

Dynamics NAV & BC Tips & tricks

NAV 2013 & NAV 2013 R2 – You do not have access to Microsoft Dynamics NAV – Create User From SQL

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…

2 June 2014

Dynamics NAV & BC Tips & tricks

Dynamics NAV – SQL Server Report Builder for Report Design

The Visual Studio Report Designer is the default report designer and it provides design functionality that SQL Server Report Builder does not support. In instances where customers who do not have access to Visual studio but need small adjustments in their reports, SQL Server Report Builder…

28 May 2014

Off-topic

Using a mapped drive for backup in SQL server

SQL server has always had this little peculiarity. The available drives for import/export of data or backup is limited to the physical drives of the computer. Any mapped drives are not visible. Bron : Aphorisms about Microsoft Dynamics NAV Lees meer...

13 May 2014

Dynamics NAV & BC Tips & tricks

SQL Server 2014 and NAV

SQL Server 2014 has gone RTM on the first of April 2014. For the moment Microsoft NAV has not yet confirmed SQL 2014 as compatible with some NAV versions. I hope they don’t wait too long. But does it has some goodies that are useful for…

16 April 2014

Dynamics NAV & BC Tips & tricks

Create a super user on a restored Dynamics NAV 2013 Database in SQL Script

Ever since Microsoft released Dynamics NAV 2013, there has been a discussion on the best way to create a user in a restored database. The problem is this: When a SQL backup is made and ported to a different environment, the Windows or Active Directory users…

30 January 2014

Dynamics NAV & BC Tips & tricks

Copy Microsoft Dynamics NAV company by SQL script into another database v2

Because the first script I have released was “two step job” and it is too complicated to use it in some automated way, I have prepared this new script, which is only modification of the original. This new script directly copy the data in one go,…

27 January 2014