This post is entirely based on the following script by Kine http://dynamicsuser.net/nav/b/kine/posts/copy-microsoft-dynamics-nav-company-by-sql-script-into-another-database-v2. If you read the comments you will note that a few people found bugs and Kine suggested he had some fixes, but I cannot find anything else. So I took it on myself to fix the bugs (they were mostly around allowing different… Read More Copy NAV Data between companies and databases using SQL