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
5
votes
4 answers

How do I rename a tSQLt test class?

I'm developing a database using the Red Gate SQL Developer tools. SQL Test, the SSMS add-in that runs tSQLt tests, lacks a way to rename test classes. I have a test called [BackendLayerCustomerAdministrationTests].[test…
Iain Samuel McLean Elder
  • 19,791
  • 12
  • 64
  • 80
5
votes
3 answers

Redgate SQL Source Control recommended workflow for dev-test-live databases

We are trying to get started with SQL Source control and have some questions. This is what I am aiming towards. Does this look like it will work? Modify dev database tables/procs Commit to dev git branch on dev PC Push changes to central…
Andy Joiner
  • 5,932
  • 3
  • 45
  • 72
5
votes
4 answers

Automating Red gate Source Control DB Linking and Commit to SVN

We have a requirement for which we want to have Red Gate Source Control as a part of the Automated Interface. We would like to programatically Link the Required Database and do Commit for the Changes to the Database. Is this possible? If yes, which…
Bandita
  • 51
  • 2
5
votes
3 answers

SSMS 2012 System.OutOfMemoryException (client side) and SQL Prompt (debug info incl)

Some background: I've been encountering this memory exception within SSMS 2012 since it was released coupled with Red Gate's SQLPrompt (this exception never happens in my SSMS 2008R2 on the same laptop). I was originally encountering these…
artofsql
  • 613
  • 4
  • 11
4
votes
4 answers

Using Schema Compare for Oracle to create deployment script

We have a large (2000+) set of scripts used to deploy out database code. Does anyone know whether there is a tool that can be used to create a single deployment script that conforms to correct dependency order? I understand that this can be done…
Zen-C
  • 71
  • 1
  • 10
4
votes
5 answers

SQL Server Collation Conflict

Transferring data from one SQL server to another but when Schema is compared and syncronised the following error is received. We are using redgate SQL compare to complete. Cannot resolve collation conflict for equal to operation Base SQL server is…
steven
4
votes
1 answer

Upgraded SSMS and now Redgate tools are missing

I recently upgraded to SSMS 2016 and the Redgate tools I have for 2014 are still there but missing in 2016. Do i need to uninstall and reinstall Redgate? If so do i need to deactivate my key before doing so? Does anyone know of a way to attach…
NormTheThird
  • 176
  • 15
4
votes
3 answers

Alternatives to Red Gate SQL Comparison SDK?

I've been using the Red Gate SQL Comparison API in a project that's getting long in the tooth. We use a fraction of its abilities and I am evaluating other options. Our scenario is basically this: We have two SQL Server 2008 databases that can be…
roufamatic
  • 18,187
  • 7
  • 57
  • 86
4
votes
1 answer

SQL Source Control is taking hours to synchronize

Situation: We use local SQL Server instances on our laptops and tie these to our SVN repositories using Red-Gate’s SQL Source Control. Initially when I was issued this laptop performing a “get latest” and “commit” synchronizations went relatively…
artofsql
  • 613
  • 4
  • 11
4
votes
3 answers

Powershell Start-Website IIS

Problem/Question I'm test running a script for redgate deployment. At the last step it starts a website: import-module WebAdministration $website = get-website | where-object { $_.name -eq $RedGateWebSiteName } #(re)write HostName# $binding =…
JochemQuery
  • 1,495
  • 2
  • 26
  • 38
4
votes
3 answers

Data loss warning adding column in the middle of a table

A new column has been added to a table, but the new column was not added to the end of the table definition (rightmost column), but the middle of the table. When I try to commit this in Redgate SQL Source Control, I get the warning "These changes…
Andy Joiner
  • 5,932
  • 3
  • 45
  • 72
3
votes
2 answers

RedGate Programmatically Link DB to SVN

We are currently reviewing the Source Control product as part of an automated developer deployment center. We would like to be able to programmatically link a DB to source control, rather than relying on the developer doing this. Is this possible…
DavidReid
  • 449
  • 1
  • 5
  • 21
3
votes
1 answer

how to check a SQL Azure bacpac is not corrupt

I just lost hours to a corrupt SQL Azure bacpac backup. None of the restore mechanisms I used reported anything wrong when restoring the backup, and schema and data seemed to be there, but given there most definitely was something wrong with that…
eglasius
  • 35,831
  • 5
  • 65
  • 110
3
votes
3 answers

Is there an easy way to add a custom migration script to SQL Compare scripts?

At my work we are currently having some serious pains pushing our database changes across environments. The issue starts to show up when we create a new non-nullable column on an existing table. The script that SQL Compare generates creates the…
Jeffrey Lott
  • 7,171
  • 6
  • 28
  • 28
3
votes
2 answers

How to commit to the develop branch in RedGate SQL Source Control

In the Commit tab, the branch shown is a grey master. In my GitHub, I have already set up a develop branch and hope to commit my changes to that branch. How can I change the working branch in RedGate SQL Source Control?
Blaise
  • 21,314
  • 28
  • 108
  • 169
1
2
3
…
15 16