SqlPackage, Synonyms, and the Third-Party Database Problem
You’ve got a SQL Server database that talks to a third-party database via synonyms. The third-party vendor lets customers customize their schema. The table names differ across environments. You use SSDT and SqlPackage for deployments….