SQL Change Automation

Discussion List

• How to populate dbo.__MigrationoLog.release_version column via powershell?

  Answered ✓ Redgate 121 views 4 comments 0 points Most recent by Monday January 1, 2019 6:11PMSQL Change Automation
• SCA seems to try and delete my database rather than update it.

  Answered Redgate 31 views 1 comment 0 points Most recent by Jessica R December 21, 2018 7:25PMSQL Change Automation
• Post-Deployment Script not working

  Answered ✓ Redgate 254 views 3 comments 0 points Most recent by Jessica R January 2, 2019 9:29PMSQL Change Automation
• How does "Always use default connection string for Shadow database" work?

  Answered Redgate 51 views 3 comments 0 points Most recent by PeterDaniels February 3, 2019 3:51PMSQL Change Automation
• Can we change the output of Changes.html to NOT included previous column with just a comma added?

  Answered ✓ Redgate 11 views 2 comments 0 points Most recent by PeterDaniels December 19, 2018 1:48AMSQL Change Automation
• Are we restricted to only using alpha characters when using semantic version migration grouping?

  Answered ✓ Redgate 11 views 2 comments 0 points Most recent by PeterDaniels December 17, 2018 3:46PMSQL Change Automation
• How do I populate the __MigrationLog columns: version, package_version, release_version?

  Answered ✓ Redgate 132 views 6 comments 0 points Most recent by PeterDaniels February 8, 2019 1:28PMSQL Change Automation
• What actions generate the schema snapshot required for drift and deploy preview reports?

  Answered ✓ Redgate 42 views 3 comments 0 points Most recent by PeterDaniels December 19, 2018 1:50AMSQL Change Automation
• How to use -Target <list> in New-DatabaseReleaseArtifact?

  Answered ✓ Redgate 41 views 6 comments 0 points Most recent by PeterDaniels December 26, 2018 5:37PMSQL Change Automation
• Excluding objects from the changes list - how to keep unchecked object scripts unchecked

  Answered Redgate 51 views 7 comments 0 points Most recent by Russell D January 2, 2019 3:48PMSQL Change Automation
• How do you actually deploy a new database from the nuget package

  Answered Redgate 1.1K views 11 comments 0 points Most recent by Sergio R April 15, 2019 12:57PMSQL Change Automation
• warning : No schema snapshot could be retrieved from the target database?

  Answered ✓ Redgate 283 views 5 comments 1 point Most recent by Jessica R December 31, 2018 6:28PMSQL Change Automation
• Migration script fails due to column rename

  Answered ✓ Redgate 203 views 4 comments 0 points Most recent by Tom_Philbrick December 13, 2018 6:30PMSQL Change Automation
• Unable to execute powershell cmdlet's in Octopus Server

  Answered ✓ Redgate 625 views 1 comment 0 points Most recent by Sergio R December 10, 2018 9:13AMSQL Change Automation
• How do I add a baseline to an existing Change Automation project

  Answered ✓ Redgate 41 views 2 comments 0 points Most recent by Sergio R December 7, 2018 2:46PMSQL Change Automation
• SQL Change Automation trying to add PK constraint that already exists

  Answered Redgate 21 views 1 comment 0 points Most recent by Sergio R December 7, 2018 9:39AMSQL Change Automation
• Azure DevOps SQL Change Automation: Build error

  Answered Redgate 242 views 2 comments 0 points Most recent by joemo65 December 6, 2018 4:57PMSQL Change Automation
• Does SQL Change Automation support Linked databases

  Answered Redgate 101 views 2 comments 0 points Most recent by nanderton December 14, 2018 7:12PMSQL Change Automation
• SCA not including filegroups

  Answered Redgate 11 views 1 comment 0 points Most recent by Sergio R December 6, 2018 3:45PMSQL Change Automation
• Manually change programmable objects?

  Answered ✓ Redgate 21 views 1 comment 0 points Most recent by Sergio R December 5, 2018 11:02AMSQL Change Automation
• Manually change programmable objects?

  Answered ✓ Redgate 21 views 1 comment 0 points Most recent by Sergio R December 5, 2018 12:56PMSQL Change Automation
• SqlChangeAutomation.Data.Schema.Ssdt.targets not found when doing a build using dotnet.exe

  Answered Redgate 1.8K views 3 comments 0 points Most recent by Sergio R December 6, 2018 4:23PMSQL Change Automation
• Powershell deployment slow?

  31 views 1 comment 0 points Most recent by Monday December 10, 2018 4:18PMSQL Change Automation
• Errors when running Sync-DatabaseSchema

  Answered ✓ Redgate 221 views 1 comment 0 points Most recent by Dan B December 3, 2018 2:44PMSQL Change Automation