SQL Migration

(0) Share

Report

Posted on by Community Member

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 (3)

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,891 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,698 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.