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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Moving table extension fields from one extension to another *data loss question"

(1) ShareShare
ReportReport
Posted on by 15
)Hi everyone,
 
I want to ask if we move some table extension fields from one extension what is the best strategy to prevent data loss?
 
The reason for moving the fields is the following. It's a project that the original partner has installed many extensions from his app source but also  for the project. After the original partner various contractors were doing various customizations creating different extensions. So, tables like sales order, warehouse shipment, warehouse pick have multiple extensions on them. Apart from the performance impact, and the difficulty to maintain and have quality solution , in the last development after creating another extension, the following problem was raised. Extension A has a dependency to Extension B, and Extension B to extension A, causing big problems with the installation of the extensions, obvioysly BC many times doesn't permit and uninstalls them.  We were called to help with the problem. A decision was taken to move the fields to a master Extension (ie A) so all extensions wont have / loop / dependencies and inherit from the master . In order to install the amended extensions will need to force the schema update. Will the data in the fields will be lost?  Can you please comment another way to solve the problem if you disagree with the approach?   ( the system runs version BC 22.4.59114.59220 )
 
Thanks in advance
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    95,714 Super User 2025 Season 2 on at
    Hi, you need to move the data into the new fields of the new extension first, as for whether data will be lost, I hope the following information can give you some tips.
    In-depth testing for Force Sync mode in Production Environment (Renaming tables, Renaming fields, Changing field type…)
    https://yzhums.com/18755/
     
    I think another difficulty in this work is the modification of the code. The old fields in the code must point to the new ones.
     
     
    Hope this helps
    Thanks.
    ZHU
  • Iron_Felix Profile Picture
    15 on at
    thanks @YUN ZHU, i was literally now before i saw your answer reading your post, and was trying to post a question but i got an access denied when i posted the question :)  How can i move data into the new fields of the new extension first? I mean we have in Extension A, a table extension 1 for the Sales Header with three new fields. In Extension B, with a table extension 2  for the sales header with another three fields. If i move these three fields from table extension 2  to extension A table 1 how can i move the data?
    Is any way to have circular dependencies and this thing to work? ie Extension A to have a dependecy to EXtehnsion B and vice versa?
    Best regards

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans