Copy NAV 2013 R2 company

Administrator

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.

mdPartnerNL

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

@mdPartnerNL; Yes indeed!

mdPartnerNL

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

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:



What I'm doing wrong?

Thanks in advance

NavImpr

Does it work on NAV 2018?
I get the same error as VectorK.