Stack Overflow
Stack Overflow

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
3
votes
1 answer

How can I automatically upgrade databases with RedGate, TeamCity and SVN

We are looking to move from manual scripts to the RedGate database source control to manage our databases. We want to make changes to stored procs/lookups etc and then just check them into to the SVN trunk which will fire a new TeamCity build. I've…
Michael Blake
  • 2,068
  • 2
  • 18
  • 31
3
votes
1 answer

SQL Server Backup with Free Space

Can a lot of free space in both SQL Server data and transaction files reduce performance when backing up and compressing files? Our DBA is using Red Gate SQL Backup Pro to backup and compress a database where the data file is 404 GB with 55% (225…
kyletme
  • 441
  • 4
  • 17
3
votes
2 answers

SQLCompare generate only diff script

Is it possible to generate only diff script using SQLCompare from Red Gate SQl Compare? In our database sync scenario we will use SQLCompare to generate diff script and will use Tarantino for applying scripts. I've played a little with sqlcompare…
isuruceanu
  • 1,157
  • 5
  • 23
3
votes
2 answers

Comparing the data of two tables in the same database in sqlserver

I need to compare the two table data with in one database.match the data using some columns form table. Stored this extra rows data into another table called "relationaldata". while I am searched ,found some solutin. But it's not working to…
user123
  • 820
  • 3
  • 14
  • 34
3
votes
1 answer

Can RedGate Data Compare Use Joins?

Using Redgate SQL Data Compare 9. This is a simplified example of what I want to do. I have the following tables: Product (ProductId, ProductName) ProductDetail (ProductDetailId, ProductId, OtherField) Id columns in both tables are…
Phil Sandler
  • 27,544
  • 21
  • 86
  • 147
3
votes
2 answers

i want to modify Redgate source control Git.xml file to include commit and push

Below is an excerpt for the git.xml file in redgates source control Commit git commit -F "($MessageFile)" -o…
Podgeypoos
  • 177
  • 1
  • 1
  • 10
3
votes
1 answer

How can I manually control dependencies using SmartAssembly?

I have several libraries that I want to obfuscate and embed using RedGate's SmartAssembly. However, SmartAssembly's UI is bizarre since it only lets me embed dependencies that it identifies. In my scenario, I have some dependencies that aren't…
Craig
  • 1,890
  • 1
  • 26
  • 44
2
votes
4 answers

How to merge changes from a source-controlled VS2010 database project to local development DB

We're trying out VS2010 database projects for a new development, using the following dev cycle: Use Management Studio to develop changes on a local DB instance (using the designers etc) Use VS2010 schema compare to sync / import these changes to…
Chris Brook
  • 2,335
  • 20
  • 24
2
votes
2 answers

Install SQL Server LocalDB on Server Core 2019 in Docker container

Within a Docker container (image = mcr.microsoft.com/windows/servercore:ltsc2019), I have downloaded the SQL Server Express 2019 installer. I have successfully downloaded the LocalDB msi with: SQL2019-SSEI-Expr.exe /Action=Download…
Bryan
  • 258
  • 3
  • 11
2
votes
0 answers

Is there a faster way to run SQL Compare through powershell?

We currently use a house written PS script to compare developers' local SQL databases with live databases to generate deployment scripts. We use Redgate SQL Compare through powershell, typically calling it as such (where $SQLComparepath is the file…
Ben Adams
  • 129
  • 1
  • 2
  • 11
2
votes
1 answer

If we Installed redgate tool "Schema Compare of Oracle" on a shared location

If we Installed Redgate tool "Schema Compare of Oracle" on a shared location, Can we access "SCO.exe" Command line from a different Machine or Network? If Yes, Can we run multiple instances at the same time? If we have more than on Developer than…
S S
  • 81
  • 2
  • 6
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
2
votes
2 answers

Cheaper alternative for RedGate ReadyRoll

RedGate ReadyRoll is wonderful DB versioning tool which works like a charm. But the only one drawback - price. I've researched what to use and found DBUp, Envolve... These tools are good but: Doesn't have ability to define Up and Down scripts to be…
Nikolay
  • 155
  • 2
  • 10
2
votes
1 answer

SQLCop tests for tSQLt - new

There was a question about having SQLCop stored procedures as tSQLt tests. And that request was answered with the link to the Dropbox with a zip file. However the link is not working anymore. RedGate page is also referring to the same DropBox…
Rapolas
  • 283
  • 3
  • 6
2
votes
2 answers

long running database mail

I've got Redgate's SQL Monitor 2 running against my 2005 production server, and I keep getting alerts about the Database mail having a long running query. I've currently got my alerts set up to flag after a minute and mark it red after 2 minutes,…
DForck42
  • 19,789
  • 13
  • 59
  • 84
1 2
3
…
15 16