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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Splitting shared tables (DataPerCompany = No) in Dynamics NAV 2017

(0) ShareShare
ReportReport
Posted on by 17

Hi everyone,

Client works with Microsoft Dynamics NAV 2017 and they have two companies in the same database. Currently, there are around 100 shared tables (DataPerCompany = No) and the client would like to separate them so that each company has its own data.

Our goal is to change these tables to DataPerCompany = Yes.

We tested this on a test environment with the Contact table and simply changed the DataPerCompany property from No to Yes. After synchronization, the data was not deleted and remained available in both companies (each company now sees its own data).

My question is:

Is changing the DataPerCompany property enough, or are there additional steps we should consider (data migration, SQL considerations, etc.)?

Has anyone done a similar separation of shared tables in NAV 2017 or similar version in a production environment?

Any advice or best practices would be appreciated.

Thank you.

I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,155 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,043 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 955 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans