Copy NAV 2013 R2 company

Administrator
Administrator Member, Moderator, Administrator Posts: 2,506
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

  • mdPartnerNL
    mdPartnerNL 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.
  • bvbeek
    bvbeek Member Posts: 32
    @mdPartnerNL; Yes indeed!
    Yours,
    Bart van Beek
    Boltrics Professionals B.V. | www.boltrics.nl
    Nekovri Dynamics | 3PL Dynamics
  • mdPartnerNL
    mdPartnerNL 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..
  • VectorK
    VectorK 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
  • NavImpr
    NavImpr Member Posts: 7
    Does it work on NAV 2018?
    I get the same error as VectorK.

Categories