Questions tagged [redgate]

Redgate Software makes tools for Microsoft Developers working with SQL, .NET, Oracle and Cloud. The tools are designed to optimise the deployment process for database development team. For .NET developers, Redgate tools help to optimise software performance and improving quality of software.

Redgate Software is a software company based in Cambridge, England. It produces specialized database management tools for Microsoft SQL Server, Oracle, MySQL and Microsoft Azure. It also produces advanced developer tools for .NET Framework, such as SmartAssembly and .NET Reflector.

Resources:

229 questions
2
votes
0 answers

SSMS in Redgate tool sql source control when Commit the changes in source control then "Command Line Error" occured

i linked my database to perforce work-space using redgate tool in sql source control,but when i commit the change to source control that is nothing but my p4 work-space given error..like.. "Command line error" Command: P4 -s submit -d "adding"…
Pramod M
  • 43
  • 6
2
votes
1 answer

link to source control system p4 in redgate tools

hi i am trying to link source control to perforce in redgate tool for sql server management studio but it throws error like Command: P4 -c C:\myworkspace_name-LT_2632\webteam\SANDBOXES\sandboxname -s sync…
Pramod M
  • 43
  • 6
2
votes
2 answers

Unit Test in Jenkins

I already have a SQL Server DB and Source control "Redgate" beside that I already connected my project to repo Github and this project also connected to Jenkins. What I need is to do some kind of unit test on a the tables, like I already got the…
NFAL
  • 185
  • 3
  • 20
2
votes
2 answers

RedGate SQL Source Control Data

I am looking into the RedGate SQL Toolbelt to allow for full database CI and am comfortable with how the tools can facilitate my needs for schema and static data. However, there will be a certain amount of data in other tables that I would like to…
Dan Def
  • 1,836
  • 2
  • 21
  • 39
2
votes
3 answers

SQL Server comparing mechanism

I have a creation script for a SQL Server database and beside it I have a test script My test Script should compare the result of my original script and the database and let me know if it is a match I need to store the resulting script in a…
NFAL
  • 185
  • 3
  • 20
2
votes
1 answer

Can I undo 'Mark as Deployed' option in ReadyRoll?

I marked 2 scripts as deployed and checked in my changes to TFS. Can I undo this in the ReadyRoll project?
dsingh23
  • 185
  • 3
  • 14
2
votes
3 answers

tSQLt Object Organization

We are using RedGate combined with SQL Test (tSQLt). In order to unit test, we install the framework on each database. Is there a way to use the tSQLt framework in such a way where your unit tests and framework objects can reside in one central…
K. Akins
  • 657
  • 1
  • 7
  • 12
2
votes
1 answer

Octopus deploy, I need to deploy all packages up till latest on promotion to QA

Here is the story, I am using RedGate SqlCompare to generate update scripts for my Dev env, each package contains only changes from current Dev version to Latest in source control. Here is an example: I create a table (package-0.1) -> Deploy to…
Ihor Bats
  • 169
  • 1
  • 12
2
votes
1 answer

RedGate SQL Comparison SDK API Licensing Issue

First of all Sorry all that I have to write the lengthy question, But it is necessary to write these things to explain my problem better. We have an installer to install our application. I want to upgrade the database through installer. So, I have…
Mehul Vaghela
  • 478
  • 4
  • 20
2
votes
3 answers

Migrations for PostgreSQL

Red-Gate has very interesting in beta software (Sql Source Control) that is installing inside SSMS and can save schema iterations through commit button. I need the same feature for postgresql, the only way i found similar to this - is log_statement…
Igor Golodnitsky
  • 4,456
  • 7
  • 44
  • 67
2
votes
1 answer

Ignore DEFAULT with Sql Compare

I recently downloaded a free trial of RedGate's SQL Compare software. I need to prove it is a useful tool to my company so we can get some liscenses, but also want to get a couple DB schemas in sync. I am trying to do a schema comparison on 2…
Cole9350
  • 5,444
  • 2
  • 34
  • 50
2
votes
2 answers

Automated Building and Release Management VS2012

Trying to make my life easier, Currently we have 4 developers working in Visual Studio 2012 and we are using TFS 2012 for source control. The project we work on is a multi-tenant web application (single source directory with multiple dbs) that is a…
PForsythe
  • 1
  • 9
2
votes
4 answers

Recreate database from RedGate checked-in scripts

We've got a SQL Server instance with some 15-20 databases, which we check in TFS with the help of RedGate. I'm working on a script to be able to replicate the instance (so a developer could run a local instance when needed, for example) with the…
carlpett
  • 12,203
  • 5
  • 48
  • 82
2
votes
1 answer

Does sql search work with SSMS 2008 R2

I can't see the red gate sql search plugin in SSMS 2008 R2. It is supposed to display in the toolbar, but it does not. I saw a version on redgate forums that is supposed to fix the issue, that did not work. I tried a repair install. Has anyone…
P.Brian.Mackey
  • 43,228
  • 68
  • 238
  • 348
1
vote
3 answers

How to create dynamic powershell query?

I have a Powershell query to get the backup of my database. But i need to have the backup the data with different names like DATABASEBACKUP_CURRENTDATE. How can i achieve this? ./RedGate.SQLAzureBackupCommandLine.exe /as: AzureServerNAME/ad:…
Balraj Singh
  • 3,381
  • 6
  • 47
  • 82