How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Question

Post reply

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Kunal Rathi

Mr or Mrs. 500

Points: 525
More actions
March 13, 2026 at 12:00 am

#4743500

Comments posted to this topic are about the item How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Kamil Ondrus SSC Rookie Points: 32 More actions · Answer 1

Hello,

parameters for "Scrip" sqlpackage action are not correct. When I tried this, error:

*** 'ExcludeSchemaValidation' is not a valid argument for the 'Script' action.

Eric M Russell SSC Guru Points: 125624 More actions · Answer 2

Can it script server/database settings and permissions too?

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Kunal Rathi Mr or Mrs. 500 Points: 525 More actions · Answer 3

No, SqlPackage cannot fully script server settings or all permissions. It mainly handles database schema and data, not complete server-level configuration.