Skip to main content

NAV 2013 R2 - How to Create a Blank Database with Blank Company?

Hi all,

It was asked to me a lot of time that how can i create a Blank Database with a Blank company in NAV 2013 R2.

It was so easy till NAV 2013 as the company creation was available in Developer Environment, but with release of NAV 2013 R2 Creating a New Blank Database with a Blank company is changed.

In this article we will see steps to achieve same.

Steps -

1. Create a New Database in NAV 2013 R2 using Developer Environment.

** I Name my Database as Blank Database.

2. In the Recently Created Database i can see only system tables as shown below -

3. Lets see what next i want -

a) Now for creating a company i need Navision Objects, so i opened a Cronus Standard database and exported all Objects.

b) But for importing objects i need a service. (Object metadata sync to SQL via Service Tier.)

c) For Creating Service i need sufficient permission to Service Account on SQL.

4. I will be using network service account to run service, so below are permission required on database.
db_datareader, db_datawriter, db_ddladmin & db_owner

5. Now i will create a service to connect to my Blank database. I will name service as BlankService.

6. Start the Service and start Importing Objects (exported in step 3) in the Blank Database. Do Not Import all objects in one Go. Break into parts as listed below.

a. Import all objects except tables. 
(Filter Import Windows with Type <>Table)

b. Import tables between 1..10000.
(Filter Import Windows with Type  = Table, and ID <=10000)

c. Import Tables between 10000..99008535 
(Filter Import Window with Type  = Table, and ID >10000 & <2000000000)

7. Now Run SyncNav-Tenant Command. How to Run SyncNav-Tenat?

8. Once SyncNav-Tenant is completed we are ready to create a company in database.
How to Create a New Company in Database?

I Named the company as Blank Company.

Let's try to open the windows / RTC Client, and yes we have successfully achieved what we planned for.

I hope you will find the post useful and let me know as comments if you have any issues.

Saurav Dhyani


Popular posts from this blog

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

Dynamics 365 Business Central 2021 release wave 2 (BC19) Released.

Hi Readers, As we all were expecting Microsoft have Released Business Central 2021 Release Wave 2 Today a.k.a BC19. In this article we will see what all is announced with the General Availability.  Starting Today Customers & Partners can start using Business Central 19. #msdyn365bc #bc19

Navision Cannot generate SSPI context State ID HY000

Hi all, Sometime while trying to connect database in classic client with windows authentication or connect to Role Tailored Client we face an error message. Error - The following ODBC error occurred: Error: [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context  State ID: HY000