Comments
Sort by recent activity
I opened a support request. Request #132233. One more thing to note is that if I import and generate the pending changes for this trigger, it still shows up afterwards again and again as pending a change. It never goes away. / comments
I opened a support request. Request #132233. One more thing to note is that if I import and generate the pending changes for this trigger, it still shows up afterwards again and again as pending a ...
My hope with this forum post was to either 1. Find out this was already a known issue or 2. Find out if other users are seeing the issue after upgrading. I will open a support ticket and include my project. I would not normally compare in this way but I just need to trouble shoot why the VS extension thinks there is a change when there clearly is not when it is checked multiple ways all showing there is no change. This seems like there is a bug , especially when it showed up right after I upgraded and there were no changes listed before. / comments
My hope with this forum post was to either 1. Find out this was already a known issue or 2. Find out if other users are seeing the issue after upgrading. I will open a support ticket and include my...
That's a good point. I forgot that SQL Compare now allows comparison between DB and project. Regardless same results with SQL compare against the DEV DB and project and VS not showing any difference between the 2 files. Here is a screen shot of both SQL compare and the project in visual studio. / comments
That's a good point. I forgot that SQL Compare now allows comparison between DB and project. Regardless same results with SQL compare against the DEV DB and project and VS not showing any differenc...
I should also note though that when it comes to the deployment it uses a power-shell script that uses variables for which server / db to use.
If ($DoDBDeploy -eq 1) {
Write-Host "Making database changes...."
$SqlCmdVariables = @{ReleaseVersion = $IterationNumber;}
$DBConnection = New-DatabaseConnection -ServerInstance $EAMDBServer -Database $PQDBName
Test-DatabaseConnection $DBConnection -ErrorAction SilentlyContinue -ErrorVariable ConnectionErrors
if ($ConnectionErrors.count -ne 0) #if we couldn't connect
{
write-warning $ConnectionErrors[0]
exit
}
if (!(Test-Path $DBDeployFile)) {
Write-Warning " $DBDeployFile does not exist"
exit
}
$DBUpdate = New-DatabaseReleaseArtifact -Source $DBDeployFile -Target $DBConnection -SqlCmdVariables $SqlCmdVariables
Use-DatabaseReleaseArtifact $DBUpdate -DeployTo $DBConnection
}
/ comments
I should also note though that when it comes to the deployment it uses a power-shell script that uses variables for which server / db to use.
If ($DoDBDeploy -eq 1) {
Write-Host "Making databas...
@PeterDaniels I don't get a TargetedDeploymentScript.sql at all. I get a PackageScript.sql in \db\output\ Here is how I am doing my build that produces a nuget package where PackageScript.sql is located.
$temporaryDatabase = New-DatabaseConnection -ServerInstance $EAMDBServer -Database $PQTempDB
$ProjectObject = $ProjectFile | Invoke-DatabaseBuild -TemporaryDatabase $temporaryDatabase
$DBDeployFile = $ProjectObject | New-DatabaseBuildArtifact -PackageId EAMDatabase -PackageVersion $PackageVersion
$DBDeployFile | Export-DatabaseBuildArtifact -Path $CopyLocation
/ comments
@PeterDaniels I don't get a TargetedDeploymentScript.sql at all. I get a PackageScript.sql in \db\output\Here is how I am doing my build that produces a nuget package where PackageScript.sql is lo...
Are you using the Schema drift options? https://documentation.red-gate.com/sca3/automating-database-changes/automated-deployments/handling-schema-drift I am not and I have never seen this TargetedDeploymentScript.sql. I would think you would not want to be using drift when you are not targeting a specific server / DB. Maybe not using drift will solve your problem. / comments
Are you using the Schema drift options? https://documentation.red-gate.com/sca3/automating-database-changes/automated-deployments/handling-schema-drift I am not and I have never seen this Target...
PeterDaniels Did you ever write a script to recurse through the migrations folder to look for the latest version? If so would you mind sharing? If not I have a need as well and will be looking into this myself. / comments
PeterDaniels Did you ever write a script to recurse through the migrations folder to look for the latest version? If so would you mind sharing? If not I have a need as well and will be looking into...
@PeterDaniels Pretty much what I did as well. I was going to read the .sqlproj file and get how it is configured instead of assuming how I think it is. Maybe I will do that later. <DeployOnceSubFolder>Migrations</DeployOnceSubFolder> <MigrationOrdering>FilePath</MigrationOrdering> / comments
@PeterDaniels Pretty much what I did as well. I was going to read the .sqlproj file and get how it is configured instead of assuming how I think it is. Maybe I will do that later. <DeployOnceSub...
This is a good question and one I am hoping to understand as well. I could write a script but seems it would be cleaner to use a built in API if possible. / comments
This is a good question and one I am hoping to understand as well. I could write a script but seems it would be cleaner to use a built in API if possible.
I am not using Octopus (yet) but I recall seeing this in the doco. https://documentation.red-gate.com/sca3/developing-databases-using-sql-change-automation/generating-deployment-scripts/variables
ReleaseVersion
1.0.0-MyRelease
Release number to store against deployed migrations within the [dbo].[__MigrationLog] table. There is no default value for this variable; a warning will be emitted during deployment if it has not been set.
The exception to this is when deploying with Octopus, in which case the value is automatically sourced from the Octopus.Release.Number system variable.
/ comments
I am not using Octopus (yet) but I recall seeing this in the doco. https://documentation.red-gate.com/sca3/developing-databases-using-sql-change-automation/generating-deployment-scripts/variables
...