Added usage documentation

brunomartinspro · web-flow · commit f49d72631a4d · 2020-01-27T11:04:51.000Z
diff --git a/docs/tools/sqlpackage.md b/docs/tools/sqlpackage.md
@@ -38,7 +38,29 @@ The **SqlPackage.exe** command line allows you to specify these actions along wi
 ```
 SqlPackage {parameters}{properties}{SQLCMD Variables}  
 ```
-  
+
+### Usage Examples
+
+**Generating a comparison between databases using .dacpac files with a SQL script output.**
+
+Start by creating a .dacpac file of your latest database changes
+
+```
+sqlpackage.exe /TargetFile:"C:\sqlpackageoutput\output_current_version.dacpac" /Action:Extract /SourceServerName:"." /SourceDatabaseName:"Contoso.Database"
+ ```
+ 
+Create a .dacpac file of your database target (that has no changes):
+
+ ```
+ sqlpackage.exe /TargetFile:"C:\sqlpackageoutput\output_target.dacpac" /Action:Extract /SourceServerName:"." /SourceDatabaseName:"Contoso.Database"
+ ```
+
+Create a SQL Script that generates the differences of two .dacpac files:
+
+```
+sqlpackage.exe /Action:Script /SourceFile:"C:\sqlpackageoutput\output_current_version.dacpac" /TargetFile:"C:\sqlpackageoutput\output_target.dacpac" /TargetDatabaseName:"Contoso.Database" /OutputPath:"C:\sqlpackageoutput\output.sql"
+ ```
+
 ### Help for the Extract action
 
 |Parameter|Short Form|Value|Description|
