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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

check whether you are getting these kind off errors

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

Was this reply helpful? Yes No
Suggested answer

dkatson 2,263 on at

Like (0)

Report

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

Was this reply helpful? Yes No