Skip to content

SqlPackage extracttarget (output format) -> SQL project #760

@dzsquared

Description

@dzsquared

Is your feature request related to a problem? Please describe.
Creating a SQL project using SqlPackage/DacFx is possible using the extracttarget property set to SchemaObjectType, ObjectType, Schema, or Flat - which generates .sql scripts for all the objects and organizes them according to the setting. However - its missing database settings/properties and the actual SQL project file.

Describe the solution you'd like
SqlPackage to be able to generate a complete SQL project.

Describe alternatives you've considered
dotnet new sqlproj (Microsoft.Build.Sql.Templates)

open questions to folks on the overall behavior:

  • should this be a change applied to the existing related extract targets (SchemaObjectType, ObjectType, Schema, or Flat ) or a wholy new extract target SqlProject?
  • do you have a scenario where the presence of a .sqlproj alongside the .sql files will create friction in using the output?

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type
No fields configured for issues without a type.

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions