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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Move Fields and Tables...
Small and medium business | Business Central, N...
Unanswered

Move Fields and Tables from extension to an other without data loss

(0) ShareShare
ReportReport
Posted on by Kichnifou 10

Hello,

Configuration : NAV 2018 in Extension V2

Today i have an extension that gather all my new field in tableextension and my new tables.

Tomorrow, I would like to reorganize my extensions, and dispach some table or field in multiple extensions.

For exemple : 

I have : Global Extenton = Tableext with Field A and Field B

I want : 2 extensions = 1 extension with tableext with field A, 1 extension with tableext with field B

What is the best way to move the data without loss ?

  • I heard about NAVApp but it's just for V1, no ?
  • I heard about Upgrade Codeunit , but it seems that it's just for new fields that needs default values or new tables that must be linked to existing records, but not for moving data, right ?
  • Do I have to use a backup database and do all my needs with an SQL script to transfert data ?

Thanks by advance

I have the same question (0)
  • Daniel Rimmelzwaan Profile Picture
    Daniel Rimmelzwaan 3,485 on at

    Unfortunately I can't share any details because that is under NDA. As soon as Microsoft is ready to share, they will publish the plan on this page: https://docs.microsoft.com/en-us/dynamics365-release-plan/2019wave2/dynamics365-business-central/planned-features/ You should also follow them on Twitter, they will probably announce it there as well

    As to your questions:

    • NavApp - Check out the PowerShell Cmdlets for app files, you will find a bunch of commands that are related to this topic. The two versions are indeed totally different. 
    • Upgrade codeunits run during the data upgrade. You can program anything you want in here. You can create a new table to replace an old table and move the data to the new table, it's all possible.
    • I doubt that you will ever *NEED* to use a database backup and SQL scripts, but they are always an option of course.

    If you are on premises, you have a lot more options than on SaaS. 

  • Kichnifou Profile Picture
    Kichnifou 10 on at

    Thanks for your answer and for the link, but it seems to be just for BC no ? I use Nav 2018

    I'll stay tuned, but according to what you said, CU upgrade seems to be the better option to do what I need, right ?

    I can't beleive that there is not an official way to do what I want properly…

  • Daniel Rimmelzwaan Profile Picture
    Daniel Rimmelzwaan 3,485 on at

    Extensions work the same way for NAV2018, maybe some newer options don't work but the basic principles are the same 

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,010

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,270 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,085 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans