private static int BuildDacpac(BuildOptions options)
{
// Set metadata for the package
using var packageBuilder = new PackageBuilder();
packageBuilder.SetMetadata(options.Name, options.Version);
// Set properties on the model (if defined)
if (options.Property != null)
{
foreach (var propertyValue in options.Property)
{
string[] keyValuePair = propertyValue.Split('=', 2);
packageBuilder.SetProperty(keyValuePair[0], keyValuePair[1]);
}
}
// Build the empty model for the target SQL Server version
packageBuilder.UsingVersion(options.SqlServerVersion);
// Add references to the model
if (options.Reference != null)
{
foreach (var referenceFile in options.Reference)
{
packageBuilder.AddReference(referenceFile);
}
}
// Add SqlCmdVariables to the package (if defined)
if (options.SqlCmdVar != null)
{
packageBuilder.AddSqlCmdVariables(options.SqlCmdVar);
}
// Add input files
if (options.Input != null)
{
foreach (var inputFile in options.Input)
{
packageBuilder.AddInputFile(inputFile);
}
}
// Validate the model
if (!packageBuilder.ValidateModel())
{
return(1);
}
// Save the package to disk
packageBuilder.SaveToDisk(options.Output);
// Add predeployment and postdeployment scripts (must happen after SaveToDisk)
packageBuilder.AddPreDeploymentScript(options.PreDeploy, options.Output);
packageBuilder.AddPostDeploymentScript(options.PostDeploy, options.Output);
return(0);
}
private static int BuildDacpac(BuildOptions options)
{
// Set metadata for the package
using var packageBuilder = new PackageBuilder();
packageBuilder.SetMetadata(options.Name, options.Version);
// Set properties on the model (if defined)
if (options.Property != null)
{
foreach (var propertyValue in options.Property)
{
string[] keyValuePair = propertyValue.Split('=', 2);
packageBuilder.SetProperty(keyValuePair[0], keyValuePair[1]);
}
}
// Build the empty model for the target SQL Server version
packageBuilder.UsingVersion(options.SqlServerVersion);
// Add references to the model
if (options.Reference != null)
{
foreach (var reference in options.Reference)
{
string[] referenceDetails = reference.Split(';', 2, StringSplitOptions.RemoveEmptyEntries);
if (referenceDetails.Length == 1)
{
packageBuilder.AddReference(referenceDetails[0]);
}
else
{
packageBuilder.AddExternalReference(referenceDetails[0], referenceDetails[1]);
}
}
}
// Add SqlCmdVariables to the package (if defined)
if (options.SqlCmdVar != null)
{
packageBuilder.AddSqlCmdVariables(options.SqlCmdVar);
}
// Add input files by iterating through $Project.InputFiles.txt
if (options.InputFile != null)
{
if (options.InputFile.Exists)
{
foreach (var line in File.ReadLines(options.InputFile.FullName))
{
FileInfo inputFile = new FileInfo(line); // Validation occurs in AddInputFile
packageBuilder.AddInputFile(inputFile);
}
}
else
{
throw new ArgumentException($"No input files found, missing {options.InputFile.Name}");
}
}
// Validate the model
if (!packageBuilder.ValidateModel())
{
return(1);
}
// Save the package to disk
packageBuilder.SaveToDisk(options.Output, new PackageOptions()
{
RefactorLogPath = options.RefactorLog?.FullName
});
// Add predeployment and postdeployment scripts (must happen after SaveToDisk)
packageBuilder.AddPreDeploymentScript(options.PreDeploy, options.Output);
packageBuilder.AddPostDeploymentScript(options.PostDeploy, options.Output);
return(0);
}
private static int BuildDacpac(BuildOptions options)
{
// Wait for a debugger to attach
WaitForDebuggerToAttach(options);
// Set metadata for the package
using var packageBuilder = new PackageBuilder();
packageBuilder.SetMetadata(options.Name, options.Version);
// Set properties on the model (if defined)
if (options.BuildProperty != null)
{
foreach (var propertyValue in options.BuildProperty)
{
string[] keyValuePair = propertyValue.Split('=', 2);
packageBuilder.SetProperty(keyValuePair[0], keyValuePair[1]);
}
}
// Build the empty model for the target SQL Server version
packageBuilder.UsingVersion(options.SqlServerVersion);
// Add references to the model
if (options.Reference != null)
{
foreach (var reference in options.Reference)
{
string[] referenceDetails = reference.Split(';', 2, StringSplitOptions.RemoveEmptyEntries);
if (referenceDetails.Length == 1)
{
packageBuilder.AddReference(referenceDetails[0]);
}
else
{
packageBuilder.AddExternalReference(referenceDetails[0], referenceDetails[1]);
}
}
}
// Add SqlCmdVariables to the package (if defined)
if (options.SqlCmdVar != null)
{
packageBuilder.AddSqlCmdVariables(options.SqlCmdVar);
}
// Add input files by iterating through $Project.InputFiles.txt
if (options.InputFile != null)
{
if (options.InputFile.Exists)
{
foreach (var line in File.ReadLines(options.InputFile.FullName))
{
FileInfo inputFile = new FileInfo(line); // Validation occurs in AddInputFile
packageBuilder.AddInputFile(inputFile);
}
}
else
{
throw new ArgumentException($"No input files found, missing {options.InputFile.Name}");
}
}
//Add Warnings options
packageBuilder.TreatTSqlWarningsAsErrors = options.WarnAsError;
if (options.SuppressWarnings != null)
{
packageBuilder.AddWarningsToSuppress(options.SuppressWarnings);
}
// Add warnings suppressions for particular files through $Project.WarningsSuppression.txt
if (options.SuppressWarningsListFile != null)
{
if (options.SuppressWarningsListFile.Exists)
{
foreach (var line in File.ReadLines(options.SuppressWarningsListFile.FullName))
{
//Checks if there are suppression warnings list
var parts = line.Split('|', StringSplitOptions.RemoveEmptyEntries);
var warningList = (parts.Length > 1) ? parts[1] : null;
FileInfo inputFile = new FileInfo(parts[0]); // Validation occurs in AddInputFile
packageBuilder.AddFileWarningsToSuppress(inputFile, warningList);
}
}
}
// Validate the model
if (!packageBuilder.ValidateModel())
{
return(1);
}
// Save the package to disk
packageBuilder.SaveToDisk(options.Output, new PackageOptions()
{
RefactorLogPath = options.RefactorLog?.FullName
});
// Add predeployment and postdeployment scripts (must happen after SaveToDisk)
packageBuilder.AddPreDeploymentScript(options.PreDeploy, options.Output);
packageBuilder.AddPostDeploymentScript(options.PostDeploy, options.Output);
if (options.GenerateCreateScript)
{
var deployOptions = options.ExtractDeployOptions();
packageBuilder.GenerateCreateScript(options.Output, options.TargetDatabaseName ?? options.Name, deployOptions);
}
return(0);
}