Import a company from other database

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.

Answers

  • JuhlJuhl Posts: 358Member
    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
    Follow me on my blog juhl.blog
  • imran-k@outlook.comimran-k@outlook.com Posts: 111Member

    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?
  • JuhlJuhl Posts: 358Member
    Yes and yes
    Its a backup
    Follow me on my blog juhl.blog
  • AntoniomvallsAntoniomvalls Posts: 14Member
    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
    Giving thanks is always wellcome
  • imran-k@outlook.comimran-k@outlook.com Posts: 111Member
    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.
  • AntoniomvallsAntoniomvalls Posts: 14Member
    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
    Giving thanks is always wellcome
Sign In or Register to comment.