Azure云环境下SQL Server数据库Bc版发布故障排查与解决方案.pdfVIP

你好，

1、为何Basic版的数据库，发布时不成功，但之前的Web（将停用），就正常。

2、我们用sqlpackage.exe，到现在此为Web版的，还是正常，但我们创建一个Basic版

的，用同样的bat（含sqlpackage语句），就总是失败。

3、我是：zcootongdev@zcootongdev1.partner.onms.cn

如下是我们的bat语句（注：sqlpackage.exe请正常设置环境变量。蓝色改为你本地的对

应IP、用户名和。红色，改为云上IP，用户名和）：

@ECHOOFF

SqlPackage.exe/a:Extract/ssn:192.168.199.7/sdn:MyDB/su:gjy/sp:abc

123456/tf:C:\MyDB.dacpac

SqlPackage.exe/a:Publish/SourceFile:C:\MyDB.dacpac/tsn:xxxxx.database.c

hinacloudapi.cn,1433/tdn:MyDB/tu:xxx/tp:xxx/p:AllowIncompatibletform=TRUE

/p:BlockOnPossibleDataLoss=False/p:DropObjectsNotInSource=True/p:IgnoreK

eywordCasing=False/p:IgnoreExtendedProperties=True/p:CompareUsinrgetColl

ation=False/p:VerifyCollationCompatibility=False

:ReadKey

SET/Puname=输入q:

你好，

1.WhyistheBasicversionofthedatabaseunsuccessfulwhenitisreleased,butthe

previousweb(willbedisabled)isnormal.2.Weusesqlpackage.exe,anditisstillnor

malfornow.However,ifwecreateaBasicversion,andusethesamebat(including

sqlpackagestatement),itwillalwaysfail.3.Myaccountis:

zcootongdev@zcootongdev1.partner.onms.cn

Thefollowingisourbatstatement(Note:sqlpackage.exePleasesetenvironmentvariabnormally.Changethe

bluecolortoyourlocalcorrespondingIP,usernameandpassword.Red,changeittocloudIP,usernameand

password):

@ECHOOFF

SqlPackage.exe/a:Extract/ssn:192.168.199.7/sdn:MyDB/su:gjy/sp:abc123456/

tf:C:\MyDB.dacpac

SqlPackage.exe/a:Publish/SourceFile:C:\MyDB.dacpac/tsn:xxxxx.database.c

hinacloudapi.cn,1433/tdn:MyDB/tu:xxx/tp:xxx/p:AllowIncompatibletform=

TRUE/p:BlockOnPossibleDataLossFalse/p:DropObjectsNotInSourceTrue/

p:IgnoreKeywordCasingFalse/p:IgnoreExtendedPropertiesTrue/

p:CompareUsinrgetCollationFal