Copy NAV 2013 R2 company

AdministratorAdministrator Member, Moderator, Administrator Posts: 2,495
edited 2014-08-05 in Download section
Copy NAV 2013 R2 company
This tool wil generate a SQL Query to copy a NAV Company between two databases!

This tool is also working if the table definitions are different in both databases: New fields or remove fields are supported

HOW TO USE:
- Import "Copy NAV Company Export.fob" in SOURCE Database and run report 75000
- Import "Copy NAV Company Export.fob" in TARGET Database and run report 75000
- Run "SQL Copy NAV Company.exe"
- Copy & paste the output to a new Query in SQL Server Management Studio

NOTE: Inside the RTC Client you have to create a new company in the TARGET database (Search for 'Companies')

DISCLAIMER: I'm not responsible of losing data!

http://www.mibuso.com/dlinfo.asp?FileID=1550

Discuss this download here.

Comments

  • mdPartnerNLmdPartnerNL Member Posts: 802
    I have created two text files and started your exe. Below is part of what the exe creates.
    USE [NAV]
    
    DELETE FROM dbo.[Test2$Payment Terms]
    GO
    print 'Payment Terms DELETE'
    INSERT INTO [dbo].[Test2$Payment Terms] (
       [Code]
      ,[Due Date Calculation]
      ,[Discount Date Calculation]
      ,[Discount _]
      ,[Description]
      ,[Calc_ Pmt_ Disc_ on Cr_ Memos]
    )
      SELECT
       [Code]
      ,[Due Date Calculation]
      ,[Discount Date Calculation]
      ,[Discount _]
      ,[Description]
      ,[Calc_ Pmt_ Disc_ on Cr_ Memos]
      FROM [NAV2].[dbo].[Test$Payment Terms]
    GO
    print 'Payment Terms INSERT'
    


    So, the two databases must be available at the same time. Will try it our later with a 2009 and 2013 database. Thx.
  • bvbeekbvbeek Member Posts: 32
    @mdPartnerNL; Yes indeed!
    Yours,
    Bart van Beek
    Boltrics Professionals B.V. | www.boltrics.nl
    Nekovri Dynamics | 3PL Dynamics
  • mdPartnerNLmdPartnerNL Member Posts: 802
    Will this work if a db is 2009R2 and the other is 2013R2 ?

    The technical upgrade from 2009 to 2013 does a lot of things with the data..
  • VectorKVectorK Member Posts: 86
    Hi all,

    I've tried this tool and it works fine with the firts company.

    With the second company I want to process the system shows the following error:

    copynav_zpsf6143fe1.png

    What I'm doing wrong?

    Thanks in advance
  • NavImprNavImpr Member Posts: 7
    Does it work on NAV 2018?
    I get the same error as VectorK.
Sign In or Register to comment.