Open Forum

1.  Import a company from other database

Posted 6 days ago
Versions: NAV 2016

We have two databases of same version 2016. One is main one which is bespoked. Other one is standard obviously data in it and has few companies. I would like to have those companies from standard one get imported to the main one as additional companies. So lets say main database has companies 1,2 and 3. The standard one has company A. The end result should be 1,2,3 and A in the main database.

How would you achieve that?

Thanks.


------------------------------
I K
Dynamics Nav Developer
------------------------------


2.  RE: Import a company from other database

Posted 6 days ago
Copying companies is simple in NAV 2016+

Use the NAV powershell.

Export-NAVData -DatabaseServer 'Servername' -DatabaseName 'DatabaseName' -CompanyName 'Company' -FilePath X:\path\to\file\filename.navdata

Import-NAVData -DatbaseServer 'Servername' -DatabaseName 'OtherDatabaseName' -CompanyName 'Company' -FilePath X:\path\to\file\filename.navdata

Export-NAVData on MSDN

Import-NAVData on MSDN

------------------------------
Ian Ray
Cypress Grove
Arcata CA
------------------------------



3.  RE: Import a company from other database

Posted 6 days ago
Thanks Ian

Is using powershell method any different from using the import/export companies from RTC? I have tried the RTC one , exported the data to navdata and on importing it throws an error as table definitions are different.

Does the powershell method also export all ledges and import to other database?

Please advise.

------------------------------
I K
Dynamics Nav Developer
------------------------------



4.  RE: Import a company from other database

Posted 6 days ago
The cmdlets and the import/export from the RTC are the same as far as I know.

If the databases are that different, you could try creating a third one and "upgrading" it to be like target with the development environment before exporting.

There is also this tool, but I have never tried it
https://mibuso.com/downloads/copy-nav-2013-r2-company

------------------------------
Ian Ray
Cypress Grove
Arcata CA
------------------------------



'