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 :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Copy setup tables from...
Microsoft Dynamics NAV (Archived)

Copy setup tables from Company A to NEw Company

(0) ShareShare
ReportReport
Posted on by mbr 5,136

We have created a new Company in the same Nav Instance.  I tried doing this in the front end but since I don't see UI in the Nav server or Client interface, I ended up creating this new company from the dev environment.

Question: is there an easy way to copy set up tables such as GL accounts, GL settings, User Setup, Users, and other set up tables?  I tried the package configuration but I don't think I am using this right.  My last resort is to perform the copy from sql side since I am more familiar with SQL server but perhaps you guys can help guide me to the right direction without involving TRANSACT SQL. :)

*This post is locked for comments

I have the same question (0)
  • mbr Profile Picture
    mbr 5,136 on at

    Ohh! I did make it work somehow. :)  'had to click apply config after importing from source db.  

  • mmv Profile Picture
    mmv 11,471 on at

    Hi,

    Were you able to copy the tables?

  • Verified answer
    mbr Profile Picture
    mbr 5,136 on at

    Yes. :)  I ended up using Transact SQL to copy.  I.e., create cursor procedures that will loop through each table for the selected company to copy into destination company.  Using the rapid start proved to be very time consuming.

  • mbr Profile Picture
    mbr 5,136 on at

    Yes. :)  I ended up using Transact SQL to copy.  I.e., created cursor procedures that will loop through each table for the selected company to copy into destination company.  Using the rapid start proved to be very time consuming.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April 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