Eric Wise

Business & .NET

Why Red-Gate Rocks My World

So we had an issue recently where a bit of code that we do not have the source for and is obfusticated (grr) was making a series of inserts and updates to the database that were causing some issues elsewhere.

Being that it was a many stepped process we weren't sure what the impact would be or even what all it was changing.

Solution: Take a backup of the database, make a copy of it, run the code routine, then fire up Red-Gate's Data Compare tool to quickly find what was modified!

Published Mar 21 2006, 12:39 PM by Eric Wise

Comments

Sahil Malik said:

I agree, I've been using Red-gate for a while, and it's saved my butt more than once.

# March 21, 2006 2:57 PM

DaRage said:

We use DbGhost... it does more than sql tasks but intergrates in development.

# March 21, 2006 3:16 PM

Josh said:

I have no idea how people developed data applications without Red-Gate in the past. It's one of my must-have tools.

# March 21, 2006 3:20 PM

Scott said:

Ummm. How about running a trace? Probably would have saved:

1. Time
2. Money
3. Client Downtime
4. Embarrassment

# March 21, 2006 6:54 PM

Ayende Rahien said:

What about just running the profiler and looking at the statements that were issued?

# March 22, 2006 12:29 AM

Eric Wise said:

The reason I didn't want to use a trace was because the application in question is a rather interesting hodgepodge of stored procedures and in line sql. Sometimes in line sql calls stored procedures and other oddities so the actual SQL Statements were not of much use to me since all I cared about what what data was actually changed where.

The snapshot of data changes was far more useful than walking through the trace log line by line.

# March 22, 2006 10:07 AM

kwgainey said:

I've recommended Red-Gate tools at 3 different companies now I've worked at. The response has always been, "Why do I need this?" or "What does it do that we can't get from a trace, a profiler, etc.?". I ask them to trace/profile the system and I'll use red-gate. I install the free trial and have the issue figured out while they're still reading the log files. After we buy it, they ask "Why didn't you say something sooner?" or "How come I never heard of this before?".

# March 23, 2006 7:31 AM

Name (required)

Your URL (optional)

Comments (required)

Remember Me?