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…
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…
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.
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).
--
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…
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…