3 ms·

Wait, so instead of using SqlPackage.exe you're using the .NET objects to do the deployment, and are auditing the changes as you deploy them? That's cool! Any

• windowsworkstoo 7y ago
  Nothing public and the assembly is basically undocumented but it's basically start with this assembly and go down the rabbit hole :) https://docs.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.transactsql.scriptdom.tsql130parser.-ctor?view=sql-dacfx-140.3881.1 https://docs.microsoft.com/en-us/dotnet/api/microsoft.sqlser... Our use case is SqlPackage builds the diff SQL, then we sanity check it using our custom code built on that parse for any DROPs / ALTERs and log/notify for confirmation