Questions tagged [readyroll]

ReadyRoll is a database Change Management tool from RedGate

ReadyRoll is a database Change Management tool from RedGate

21 questions
0
votes
1 answer

How to set DriftOptionBlockDataLoss to false in SQL Change Automation VSTS release plugin

I'm running the latest SQL change automation vsts plugin. I added a new migration script doing the following ALTER my_table ADD [description] varchar(max) NULL When the release is been deployed i got the following…
0
votes
1 answer

How do I include Db changes in deployment using ready-roll component in build definition of project ? CICD

I am using ready-roll for generating the migration script. I have three environments - DEV, UAT and PROD which has one build definition and 3 release definition in VSTS. I don't know what should i include in build definition and release definition…
S2K
  • 1,185
  • 3
  • 27
  • 55
0
votes
0 answers

Cannot Modify VS2017 on installer.exe

I'm trying to manually deselect Redgate Readyroll when Modifying the components on installer.exe but I'm always getting this error. And when I click OK, I'm stuck to the "Getting things ready" message. Can someone please help. Thanks.
jengfad
  • 704
  • 2
  • 8
  • 20
0
votes
2 answers

Conditional logic in migration scripts using ReadyRoll

I have a project that uses ReadyRoll and a script with a migration header which uses a condition to either run the script or not based on a variable defined in the SQLCMD Variables section of the project properties ($(Environment). --
Gun
  • 83
  • 3
  • 7
0
votes
0 answers

ReadyRoll Project: An item with the same key has already been added

I did the import earlier. The target database that I was using was deleted accidentally but it was restored from the backup. When I did a refresh, I found the following error, An item with the same key has already been added The shadow database…
dsingh23
  • 185
  • 3
  • 14
0
votes
0 answers

ReadyRoll Project: Octopus Deploy - Unable to get DefaultDataPath, DefaultLogPath & DefaultBackupPath

I am trying to deploy my database using Octopus Deploy and I get the following error, Could not retrieve a value for DefaultDataPath : Exception calling "Open" with "0" argument(s): "Login failed for user" I have verified all the paths but it still…
dsingh23
  • 185
  • 3
  • 14
1
2