Import a company from other database

Developer101

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.

Juhl

In 2016 you need to use powershell, no gui anymore.
https://msdn.microsoft.com/en-us/library/dn789595(v=nav.90).aspx

Meet me at https://Juhl.blog

Developer101

Juhl wrote: »

In 2016 you need to use powershell, no gui anymore.
https://msdn.microsoft.com/en-us/library/dn789595(v=nav.90).aspx

Meet me at https://Juhl.blog

Will this method copy ledger entries as well? Do the table definitions need to be same on both databases?

Juhl

Yes and yes
Its a backup

Antoniomvalls

If u have the same version and same objects in the databases you can export and import them from IT Configuration.

Search for import/export. The result extension archive is NAVData. Search on google for this functionallity

Developer101

Antoniomvalls wrote: »

If u have the same version and same objects in the databases you can export and import them from IT Configuration.

Search for import/export. The result extension archive is NAVData. Search on google for this functionallity

Objects are not the same but Nav versions are the same.

Antoniomvalls

imran-k@outlook.com wrote: »

Antoniomvalls wrote: »

If u have the same version and same objects in the databases you can export and import them from IT Configuration.

Search for import/export. The result extension archive is NAVData. Search on google for this functionallity

Objects are not the same but Nav versions are the same.

Then you cannot do it, sorry