redgate

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 or a framework (to use programatically) with built-in features to do that? Or is there som...

How good are Redgate's SQL tools?

I'd like to hear from anyone who has experience with Redgate's tools for Sql Server 2005. In particular, are their backups 100% reliable? Their claims about backup speed and compression sound almost too good to be true. For those who have used Redgate's backup, do they handle transaction log backups (and therefore restoring up to a sp...

Are there any free alternatives to Red Gate's tools like SQL Compare

Any tools as useful as these? ...

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 SQL_Latin1_General_CP1_CI_AS and the destination server is Latin1_General_CI_AS ...

How to get RedGate Data Compare to consider sort order?

I am using SQL-Server 2005. I have a dev and prod database that have essentially the same data in them. When I do a compare with RedGate SQL Data Compare 5, it says that only 4 records differ. However, when I open up the tables and view them, they are in a completely different sort order. Neither table has an index or anything forcin...

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

Hi all, 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 column as non-nullable, so it will always fail. I was hoping that there was some al...

How to execute 3GB SQL file (Micrsoft SQL Server)?

I have a big SQL file that does not fit into memory and that 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 cannot split the script because it is generated by Redgates excellent SQL Data Compare. the...

Is there an equivalent of Redgate SQL Compare for MySQL databases?

Joel is always talking about how great SQL Compare from Redgate software is. SQL Compare only works with Microsoft SQL Server databases, but is there a good piece of software that works with MySQL and the other common databases that are part of the LAMP stack (PostgreSQL, Oracle, etc)? ...

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 Queue? Can you point me to the best definition? Can you share any anecdotal advice? Also, all ...

Redgate's SQLCompare Schema Comparison Not Removing or Adding Objects Via Command Line

I have a saved SQLCompare project which I use to synchronize my local database with another "master" database. When I run the project via the GUI, everything works fine. However when I run it via the command line, only objects that exist on both sides get synchronized. For example, if a column is added to or removed from a table, that ch...

Redgate profilers equivalent for .Net Sharepoint

Hi: I was wondering whether there are any recommended open source performance and memory profilers equivalent to Redgate? This is for .Net and SharePoint development. Thanks. Chris. ...

How do i stop log4net from logging when running tests in NUnit TestRunner

Let me explain my scenario first: I have around 2000 tests to run, which take about 30 seconds in NUnit I want to find out what's taking the time I open Ants Profiler, and get it to profile the NUnit TestRunner, and load my test dll into the TestRunner I then run the tests... However, running the tests whilst profiling takes a lot lo...

Redgate Visual Studio addin

Hi there, I realise that this may be subjective (and would appreciate not being voted down on this one XD), but I would like some advice from other developers out there who have used RedGate's .Net productivity addins - ANTS Performance Profiler Pro, ANTS Memory Profiler, and Excpetion Hunter. Its quite pricey, and basically, does anyo...

What other products are similar to Redgate's SQL Search?

What other products are similar to Redgate's SQL Search? Redgate just released "SQL Search" in Feb 2010. http://www.red-gate.com/products/SQL_Search/index.htm I am still amazed this type of search is not already built into SQL Server Management Studio. Updated: If you are curious. Here is the story how SQL Search got developed. htt...

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 Generate Initial Test Data.sql Migration 0001_MigrationScriptForChangeOne.sql 0...

Migrating an ERP product to SQL 2008 (regular or R2) from 2000.

We are running a version behind the latest for our ERP system which runs on SQL Server 2000. My version is not supported on 2008 (regular or R2). In fact, the latest version of the ERP is not certified to work with R2 (which isn't surprising since it hasn't been released yet) I have done some preliminary testing with 2008 and it appears...

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 = ddl, but log need be transformed and saved properly to file and than commited. What is y...

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 assumed to have identical schemas. The databases are tiny. Most tables have less than 1...

RedGate shows percents instead of milliseconds

I tried to compare RedGate performance profile on two different machines and to my surprise the on one RedGate shows milliseconds but no code text (there is no source) and on another it shows code text with percentage against worked lines. How can I see milliseconds? P.S. I am sure I picked Wall Clock in settings on both machines. ...

How can I trace where potential exceptions might be thrown from?

We have many questions here about stack traces and analyzing exceptions that have been thrown. I am using RedGate Reflector to examine the workings of some .net classes. In particular, I am looking at the ConnectionString property of the System.Data.SqlClient.SqlConnection object. Reflector indicates that this property may throw an Ar...