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
371
votes
9 answers

Something better than .NET Reflector?

I used to love .NET Reflector back in the day, but ever since Red Gate Software took over it has gone downhill dramatically. Now it forces me to update (which is absolutely ridiculous), half the time the update doesn't go smoothly, and it is…
Josh Stodola
  • 81,538
  • 47
  • 180
  • 227
22
votes
4 answers

Anybody using SQL Source Control from Red Gate

We have been looking into possible solutions for our SQL Source control. I just came across Red Gates SQL Source control and wondered if anyone has implemented it? I am going to download the trial and give it a shot, but just wanted to see if…
scarpacci
  • 8,957
  • 16
  • 79
  • 144
17
votes
4 answers

SQL Search does not start in SSMS 18.5

I have updated SSMS to v18.5 and then uninstall SQL Search, downloaded the latest one and installed. SSMS started, I click button "SQL Search" - no any errors/exceptions but SQL Search does not start. I have repeated these actions on 2 workstations…
ZedZip
  • 5,794
  • 15
  • 66
  • 119
15
votes
11 answers

how to compare/validate sql schema

I'm looking for a way to validate the SQL schema on a production DB after updating an application version. If the application does not match the DB schema version, there should be a way to warn the user and list the changes needed. Is there a tool…
Ron Harlev
  • 16,227
  • 24
  • 89
  • 132
14
votes
6 answers

Is RedGate SQL Source Control for me?

I've just inherited an SQL Server database. One of the things I will need to sort out is versioning and automated builds. It has been suggested that I should think seriously about recommending RedGate SQL Compare, but I have to admit I am a little…
NeedHack
  • 2,943
  • 3
  • 30
  • 44
13
votes
2 answers

SQLCop tests for tSQLt

The Redgate tool SQLTest for SQL unit testing now offers the ability to add tests from SQLCop however the Redgate tool only comes with few of those tests prebuild. Since tests are just stored procedures I am sure somebody has implemented more of…
lstanczyk
  • 1,313
  • 13
  • 20
12
votes
2 answers

Getting error "commandtext property has not been initialized" when sql compare of Red Gate

When I compare the 2 databases with the Red Gate's SQL compare then getting below error. "ExecuteReader: CommandText property has not been initialized" I am using the SQL server 2012 express and Red Gate's SQL Compare 8 Is there any…
Tushar Maru
  • 3,347
  • 10
  • 34
  • 53
10
votes
3 answers

What are the Finalizer Queue and Control+ThreadMethodEntry?

I have a WindowsForms app that appears to leak memory, so I used Redgate's ANTS Memory Profiler to look at the objects I suspect and find that they are only held by objects already on the Finalizer Queue. Great, exactly what is a the Finalizer…
flipdoubt
  • 13,897
  • 15
  • 64
  • 96
6
votes
3 answers

Database Change Management - Setup for Initial Create Scripts, Subsequent Migration Scripts

I've got a database change management workflow in place. It's based on SQL scripts (so, it's not a managed code-based solution). The basic setup looks like this: Initial/ Generate Initial Schema.sql Generate Initial Required Data.sql …
Martin Suchanek
  • 3,006
  • 6
  • 31
  • 31
6
votes
1 answer

Understanding memory leaks in ASP.net using RedGate Memory Profiler

I am running a large ASP.net 4.0 website. It uses a popular .Net content management system, has thousands of content items, hundreds of concurrent users - is basically a heavy website. Over the course of 1 day the memory usage of the IIS7 worker…
rf_wilson
  • 1,562
  • 5
  • 32
  • 44
6
votes
1 answer

Linked Tables in Red-Gate SQL Source Control (SSC) - Performance Nightmare?

Our team is using Red-Gate SQL Source Control as our database CM tool. After performing a quick test to determine how linking static data affects the speed of SQL Source Control, I got the following results: 1st run -- 85 seconds (26 linked…
stonetiger
  • 96
  • 4
5
votes
8 answers

How to execute a 3GB SQL file (Microsoft SQL Server)?

I have a big SQL file that does not fit into memory and needs to be executed against Microsoft SQL Server 2008. It seems that the sqlcmd.exe tool always loads it into memory first which is impossible in this case. Any ideas? Unfortunately, I can't…
tobi
5
votes
1 answer

RedGate SQL tools v Microsoft Visual Studio Team System Database Edition (Data Dude)

I've been looking at RedGate's SQL tools and Microsofts Visual Studio Team System Database Edition (formerly Data Dude) for use within a testing and continuous integration environment. What we need to be able to do is have: Schema and Data under…
5
votes
3 answers

ApexSQL Complete or Redgate SQL Prompt?

I have been using Redgate SQL Prompt so far. But I came to know about ApexSQL Complete which has the same features and is FREE!. Has anyone used both the tools and has any idea if ApexSQL Complete offers all features of SQL Prompt and any reason to…
missingsemicolon
  • 480
  • 1
  • 10
  • 23
5
votes
2 answers

Which source control system to use with Red Gate SQL Source Control

We are planning on using Red Gate SQL Source Control, but have not yet decided which source control system to use yet: you can use Subversion (SVN) or Team Foundation Server (TFS). Which one should we choose and how does that affect the way Red Gate…
Craig
  • 4,111
  • 9
  • 39
  • 49
1
2 3
15 16