News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) SQL Migration

Microsoft Dynamics NAV (Archived)

SQL Migration

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi Everyone,

I have 3 companies in native database. I have done with SQL migration for 1st company with the help of following link https://community.dynamics.com/nav/b/sauravdhyanimicrosoftdynamicsnav/archive/2014/09/08/how-to-restore-native-backup-to-sql-database-sql-migration

I have changed to 2nd company and Same process i am doing for 2nd company but it's not taking 2nd company. Please suggest me how to do SQL migration for other companies.

Thank you,

Madhavi

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

dkatson 2,263 on at

Like (0)

Report

RE: SQL Migration

I suggest to make NAV backup per company and restore it by company also.

Also check that you don't have wrong (before 1700 year) data fields in you current NAV database
Suggested answer

Maneesha 5,889 on at

Like (0)

Report

RE: SQL Migration

check whether you are getting these kind off errors

community.dynamics.com/.../how-to-restore-native-backup-to-sql-database-sql-migration
Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: SQL Migration

Are you restoring backup company wise ? If so then try with DB backup which will contain all companies and then try to migrate to sql.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans