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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Getting errors importi...
Microsoft Dynamics AX (Archived)

Getting errors importing BACPAC file to a new Azure SQL Database

(0) ShareShare
ReportReport
Posted on by Gildo Calvanese 142

Hi all, 

I Exported the database AXDB ( the SQL version is : SQL server Microsoft SQL Server 2016 (SP1-CU5) (KB4040714) - 13.0.4451.0 (X64)   Sep  5 2017 16:12:34   Copyright (c) Microsoft Corporation  Developer Edition (64-bit) on Windows Server 2016 Datacenter 6.3 <X64> (Build 14393: ) (Hypervisor))   with the command :

SqlPackage.exe /a:export /ssn:localhost /sdn:AxDB /tf:D:\Exportedbacpac\AxDBxxxUpdate.bacpac /p:CommandTimeout=999999999 /p:VerifyFullTextDocumentTypesSupported=false

and this command generated the .bacpac file with success after 8 hours. The size of DB is 300GB.

But I'm not able to import  BACPAC file to a new Azure SQL Database. When I tried to import in T2 enviroment with SQL Azure ( Microsoft SQL Azure (RTM) - 12.0.2000.8   May  4 2018 13:05:56   Copyright (C) 2018 Microsoft Corporation ) I receved this error :

3056.error.jpg

C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin>SqlPackage.exe /a:import /sf:D:\dbAx_da_migrazioneVM\AxDBxxxxUpdate_old.bacpac /tsn:sxxxxxxxxxx.windows.net /tu:sqladmin /tp:password /tdn:AxDBdaMigrazioneVM /p:CommandTimeout=999999999 /p:DatabaseEdition=Premium /p:DatabaseServiceObjective=P2
Importing to database 'AxDBdaMigrazioneVM' on server 'xxxxxxx.windows.net'.
Creating deployment plan
Initializing deployment
*** A project which specifies SQL Server 2016 as the target platform may experience compatibility issues with Microsoft Azure SQL Database v12.
Verifying deployment plan
Analyzing deployment plan
Importing package schema and data into database
Updating database
*** Error importing database:Could not import package.
Warning SQL0: A project which specifies SQL Server 2016 as the target platform may experience compatibility issues with Microsoft Azure SQL Database v12.
Error Deploy72002: Value was either too large or too small for an Int16.

Value was either too large or too small for an Int16.

I Imported the bacpac on T2 machine with this command :

SqlPackage.exe /a:import /sf:D:\dbAx_da_migrazioneVM\AxDBxxxxUpdate_old.bacpac /tsn:xxxxxxdatabase.windows.net /tu:sqladmin /tp:xxxx /tdn:AxDBdaMigrazioneVM /p:CommandTimeout=999999999 /p:DatabaseEdition=Premium /p:DatabaseServiceObjective=P2.

Anyone helps me?

Thanks in advance.

Best ragards,

Gildo

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Gildo Calvanese Profile Picture
    Gildo Calvanese 142 on at

    Hi all,

    I solved the issue. I set the p:CommandTimeout = 0 

     SqlPackage.exe /a:import /sf:D:\dbAx_da_migrazioneVM\AxDBxxxxUpdate_old.bacpac /tsn:xxxxxxdatabase.windows.net /tu:sqladmin /tp:xxxx /tdn:AxDBdaMigrazioneVM /p:CommandTimeout=0 /p:DatabaseEdition=Premium /p:DatabaseServiceObjective=P2.

    Thank you.

    Best regards,

    Gildo

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans