web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Import-NAVData cmdlet ...
Microsoft Dynamics NAV (Archived)

Import-NAVData cmdlet issue NAV 2013 R2 build 37563

(0) ShareShare
ReportReport
Posted on by Jatin Patel 2,641

Hi,

NAV 2013 R2 build 37563

We have export one company B from one database using Export-NAVData with parameter IncludeGlobalData and IncludeApplicationData.
then we import this company B in another database having company A using Import-NAVData with parameter IncludeGlobalData and IncludeApplicationData.

In NAV, we have property data per company set to NO for tables User, Permission and Permission Set.
So how it will handle data for both companies. In our case, it keep data for only company B and delete the data from company A.
I think it should keep data for both companies A and B.

Can anyone have any suggestion on this?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Jatin Patel Profile Picture
    Jatin Patel 2,641 on at
    RE: Import-NAVData cmdlet issue NAV 2013 R2 build 37563

    Hi,

    i have tested both the scenarios 3 tables.

    1. Without IncludeGlobalData
      1. User Table - No Change.
      2. Permission Table - Replaced with source database data in destination database.
      3. Permission Set Table - Replaced with source database data in destination database.
    2. With IncludeGlobalData
      1. User Table - Replaced with source database data in destination database.

      2. Permission Table - Replaced with source database data in destination database.

      3. Permission Set Table - Replaced with source database data in destination database.

     So, outcome so far is we have to handle Users, Permissions and Permission Sets in destination database already exists companies, because it will replaced with new imported company data.

  • Jatin Patel Profile Picture
    Jatin Patel 2,641 on at
    RE: Import-NAVData cmdlet issue NAV 2013 R2 build 37563

    Hi Suresh,

    It should be not like that. And it is not written anywhere in Microsoft Document.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 47,876 Super User 2025 Season 2 on at
    RE: Import-NAVData cmdlet issue NAV 2013 R2 build 37563

    Jatin,

    Since they are shared among companies i think when you export the data with GlobalData and ApplicationData set to true it will replace the data, i don't think there is an option to merge the data.

  • Jatin Patel Profile Picture
    Jatin Patel 2,641 on at
    RE: Import-NAVData cmdlet issue NAV 2013 R2 build 37563

    Hi Mahesh,

    I know that User, Permission and Permission Set are shared among the Companies. But my question is that why it will not merge records while importing company.

  • mmv Profile Picture
    mmv 11,471 on at
    RE: Import-NAVData cmdlet issue NAV 2013 R2 build 37563

    Hi,

    Permission, User and Permission Set are shared among the Companies.  But in the Access Control table, you have a field for storing the Company Name.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans