Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
getting below error while trying to deploy bacpac files from localc computer to Fabric with using of SQL Package from CMD and working fine for some of the DB's but not for many,
C:\Windows\System32>sqlpackage /action:import /sourcefile:"C:\Users\Documents\SQL Server Management Studio\DAC Packages\GenericPipelineStore.bacpac" /targetconnectionstring:"Data Source=xxxxxxx.msit-database.fabric.microsoft.com,1433;Initial Catalog=7cbcd3b-fece-4427-ac5d-7cd3eac9380b;Multiple Active Result Sets=False;Connect Timeout=30;Encrypt=True;Trust Server Certificate=False;Authentication=Active Directory Interactive"
Importing to database 'XXXXX-27cbcd3b-fece-4427-ac5d-7cd3eac9380b' on server 'x6eps4xrq2xudenlfv6naeo3i4-otw4ignqnx7elnhkumn3gw4qui.msit-database.fabric.microsoft.com,1433'.
Creating deployment plan
Initializing deployment
*** A project which specifies Microsoft Azure SQL Database v12 as the target platform may experience compatibility issues with Fabric mirrored SQL database (preview).
*** Error importing database:An error occurred during deployment plan generation. Deployment cannot continue.
Warning SQL0: A project which specifies Microsoft Azure SQL Database v12 as the target platform may experience compatibility issues with Fabric mirrored SQL database (preview).
Cannot open server "xxxxxxxxxx.msit-database.fabric.microsoft.com" requested by the login. The login failed.
As per the error you shared, it seems to be related to compatibility issues. Ensure that the target Fabric mirrored SQL database is compatible with the version specified in your .bacpac file. You might need to adjust the compatibility level of the target database.
Error importing database:An error occurred during deployment plan generation. Deployment cannot continue. Warning SQL0: A project which specifies Microsoft Azure SQL Database v12 as the target platform may experience compatibility issues with Fabric mirrored SQL database (preview)
Please provide support if you found this helpful.
yes, I am able to connect from SSMS by providing server name and database name.
If you test connecting to the database from a tool like SSMS, Azure Data Studio, or VS Code - are you able to connect?