@echo off

SET Schema=%1
SET ServerIP=%2
SET ServerPort=%3
SET UserID=%4
SET Passwd=%5
SET DBName=%6

::create update sql file
sqlpackage /Action:Script /SourceFile:./dacpac/%Schema%.dacpac /TargetConnectionString:"server=%ServerIP%,%ServerPort%; user id=%UserID%; password=%Passwd%; database=%DBName%; TrustServerCertificate=true" /OutputPath:"./%Schema%_Update.sql" /p:CommentOutSetVarDeclarations=True