TargetFile validation on Extract

[dzsquared]

• SqlPackage or DacFx Version: SqlPackage 19.1
• .NET Framework (Windows-only) or .NET Core: .net core
• Environment (local platform and source/target platforms):

Steps to Reproduce:

1. Extract a database with the extracttarget property set to anything other than the default (dacpac), set the target file to either a folder path or a *.sql file
2. Receive an error that the target file isn't a .dacpac The TargetFile argument must refer to a file with a '.dacpac' extension.

(new error related to the addition of /p:ExtractTarget)

[ErikEJ]

@dzsquared Is this really not fixed yet?

[ErikEJ]

@dzsquared @zijchen "good first issue" 😄 - if only this was open source, I would be happy to take it!

[zijchen]

Fixed with 162.1.167

[ErikEJ]

Looking forward to testing this and updating my blog post here https://erikej.github.io/efcore/dotnet/azure/dacfx/2023/08/31/from-database-to-ef-core-webapi-via-cli.html

[ErikEJ]

It works great! Allowing the following CLI work flow:

Create the database project - .dacpac package

Run sqlpackage to create .sql scripts for all objects from the Azure SQL Database in a folder:

sqlpackage /a:Extract /p:ExtractTarget=SchemaObjectType /tf:AdventureWorks /scs:"data source=myserver.database.windows.net;initial catalog=AdWorks;user id=sqlfamily;password=sqlf@m1ly;encrypt=True;Connect Timeout=60" 

For details on the sqlpackage extract action syntax, see the documentation here.

Use the sqlproj template to create a new SQL project:

dotnet new sqlproj -n AdventureWorks

Finally, you can build a .dacpac package, which can be used to publish the database schema in your deployment scripts and as the basis for code generation in the following steps.

dotnet build .\AdventureWorks\AdventureWorks.sqlproj

You should see output similar to this, to confirm that the .dacpac package is built:

  Writing model to C:\Temp\PowerTools\AdventureWorks\obj\Debug\Model.xml...
  AdventureWorks -> C:\Temp\PowerTools\AdventureWorks\bin\Debug\AdventureWorks.dll
  AdventureWorks -> C:\Temp\PowerTools\AdventureWorks\bin\Debug\AdventureWorks.dacpac