Stack Overflow
Stack Overflow

Questions tagged [readyroll]

ReadyRoll is a database Change Management tool from RedGate

ReadyRoll is a database Change Management tool from RedGate

21 questions
5
votes
2 answers

VS2019 error with SQL Change Automation: "Keyword not supported: 'multiple active result sets'"

I don't know where this error comes from at all. I have set up SQL Change Automation in VS2019 and began to get these errors for each .sqlproj solution I have. The errors are marked in the .sqlproj file, but no line is given for any of them. I also…
Heathcliff
  • 3,048
  • 4
  • 25
  • 44
4
votes
2 answers

How to Integrating tSQLt tests with Visual Studio Team Services?

I had developed simple Ready Roll database project by following this Getting started with ReadyRoll. After that I added the tSQLt tests in VS2015 using tSQLt adapter by following this Running tests in ReadyRoll with tSQLt Adapter. Next check in my…
Pradeep
  • 5,101
  • 14
  • 68
  • 140
2
votes
0 answers

Not able to view the Database Diff Report in Azure Devops Build pipeline

I was able to use the Redgate Ready Roll extension in Azure Devops Build and Release Pipeline. Everything was working fine till 8th April,2019. Now, suddenly I am facing below challenges. I am not able to view the Database Diff Report in…
nikita kakraniya
  • 141
  • 2
  • 14
1
vote
1 answer

Readyroll : Getting Error While Build using VSTS : Drift analysis: These changes will NOT be applied because DriftOptionBlockDataLoss=True

Some of the scripts were migrate manually without using readyroll script. Now any new push to dev branch fails with following error : DB\DB.sqlproj(0,0): Error : Drift analysis: These changes will NOT be applied because…
S2K
  • 1,185
  • 3
  • 27
  • 55
1
vote
1 answer

Redgate Extension for Visual Studio

I want to know if there is a Redgate Extension for Oracle databases in Visual Studio similar to "ReadyRoll SQL Server Database Project" which supports SQL Server databases only ?? Thank you all.
M.M
  • 21
  • 3
1
vote
1 answer

Jenkins build warnings "source file does not exist" with OctoPack and ReadyRoll

I'm trying to set up a Jenkins build project with ReadyRoll. Mostly it is working but I'm getting warnings that concern me: MSBUILD : OctoPack warning OCTNOENT: The source file…
Dar
  • 383
  • 1
  • 5
  • 16
1
vote
1 answer

Deploy ReadyRoll Database Package task gives error as “‘sqlcmd.exe’ is not recognized as an internal or external command"

I added the Deploy ReadyRoll Database Package task in VSTS release definition for deploying the ReadyRoll SQL Server Database Project using Migration Approach. I followed this link to create ReadRoll SQL Server Database Project in VS2017. I…
Pradeep
  • 5,101
  • 14
  • 68
  • 140
1
vote
1 answer

ReadyRoll server details for VSTS Build phase

I am trying to implement the CI/CD for ReadyRoll. For the release portion I am using an Azure SQL Server so I have specified the server name, db name and cred there. However, I am not sure what details do I give for the build component when creating…
Stewart Viera Vega
  • 13
  • 2
1
vote
1 answer

VSTS Build + Azure Database + Redgate ReadyRoll

I'm trying to make a CI/CD pipeline for my database on VSTS and deploy it on an Azure SQL Server using Redgate ReadyRoll. But I'm stuck at the build process. Here are the tasks I use : Setup a Shadow DB Build solution Copy Publish…
Thibault
  • 446
  • 7
  • 17
1
vote
1 answer

Concurrent Feature Development with Database Deployment Tool

I am looking for a specific strategy / convention that works for concurrent development with Feature branches and a database deployment tool such as DbUp, DbDeploy, ReadyRoll, etc. We run multiple feature branches for concurrent project…
JDBennett
  • 1,323
  • 17
  • 45
1
vote
1 answer

In VS 2017 community edition there is no option to install readyroll core

I have installed SQL 2016 Dev edition and VS 2017 Community edition. Documentation suggests that readyroll core is supported in the community edition. When I look at the VS2017 installer readyroll is missing. Shouldn't I be able to to install it?
user2033791
  • 810
  • 12
  • 23
1
vote
1 answer

RedGate ReadyRoll MySQL support?

Does RedGate ReadyRoll support MySQL databases? Can anyone provide a list of supported databases? Thanks!
Moto
  • 1,131
  • 2
  • 10
  • 15
1
vote
1 answer

Automatically Set DeployChangesExecutionOrder

Is there a way to automatically set the Deployment Order based on dependancy (DeployChangesExecutionOrder)? Seems like this is something that should be automatically done upon project import?
randomsolutions
  • 2,075
  • 1
  • 19
  • 22
1
vote
1 answer

SSMS: Database could not be detected as it is linked. Make sure that the user has linked a database to source control

My colleague has tried RedGate's product "Ready Roll" on our database which is also linked to Sql Source Control (also RedGate). After he uninstalled Ready Roll, none of us (him nor the rest of our team) can alter any stored procedures or make…
Louis Somers
  • 2,560
  • 3
  • 27
  • 57
1
vote
1 answer

ReadyRoll Project: SemVer Option

I am trying to use ReadyRoll project for automated deployments. the previous project that I created had the following IF TYPE_ID(N'[dbo].[abc_PrintType]') IS NULL, in the first migration script that was generated after importing the database. I…
dsingh23
  • 185
  • 3
  • 14
1
2