web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Getting error in datab...
Finance | Project Operations, Human Resources, ...
Suggested answer

Getting error in database schema update in our on-premise VM.

(0) ShareShare
ReportReport
Posted on by muttakin 95

Hello Community,

We want to take a copy of our running Dynamics 365 Finance and Operations instance to our on-premise VM. For that purpose we did a setup in our on-premise VM by downloading the VHD from LCS. But we didn't get all our customizations and data. To get back the data we tried to update the database schema of the database by following this link.

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/dbmovement-scenario-exportuat

But we ended up getting this error message:

"Error importing database: Could not read schema model header information from package. The model version 3.6 is not supported."

We also use 3 VM for FAO customizations purpose but we don't face any problem there. I am giving the version of Sql server and SSMS here.

The Version of our On-Premise VM:

Sql Server Version: Microsoft SQL Server 2016 (SP2-CU14) (KB4564903) - 13.0.5830.85 (X64)

SSMS Version: 18.4

 

The Version of VM for Customizations of FAO:

Sql Server Version: Microsoft SQL Server 2016 (SP2-GDR) (KB4293802) - 13.0.5081.1 (X64)

SSMS Version: 17.9.1

 

Can anyone recommend some workable solutions on this?

Thanks In Advance

I have the same question (0)
  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at
    RE: Getting error in database schema update in our on-premise VM.

    Hi,

    You will need to download the latest Data tier application framework.

    Please check this thread. It discusses the same issue.

  • muttakin Profile Picture
    muttakin 95 on at
    RE: Getting error in database schema update in our on-premise VM.

    I have done this but didn't work either.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at
    RE: Getting error in database schema update in our on-premise VM.

    Have you tried upgrading the SSMS version as well?

  • Suggested answer
    Anup Shah MSFT Profile Picture
    Anup Shah MSFT on at
    RE: Getting error in database schema update in our on-premise VM.

    Don't try using the DAC version. Use the sqlpackage core from here https://docs.microsoft.com/en-us/sql/tools/sqlpackage-download?view=sql-server-ver15#get-sqlpackage-net-core-for-windows. Download the zip file and extract it to a folder then use the sqlpackage from the extracted folder.

    Rest of steps at https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/import-database

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 753

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 752 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 534 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans