Share
Report
142Hi 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 :
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)
All responses (
Answers (
