QAInsight.net, QABlog.com, QABlog.net
Brent Strange's thoughts on Software Quality Assurance and technology

 
Wednesday, February 14, 2007
  
 

I need SQL data differencing tool for testing

  
 

I'm currently looking for a SQL data differencing tool that has the features:

  • Support for SQL 2000 and 2005
  • For the purpose of database migration testing, allow data snapshot comparisons. Tools I've encountered so far allow you to compare two, up and running databases which isn't what I want to do. I want to snapshot a database, run my database upgrade installer, snapshot after the upgrade and then compare the two snapshots.

I've been recommended and have reviewed the following but they don't meet my 2nd criteria:

AdeptSQL Diff

Red Gate SQL Compare

What are you using? Do you know of a tool that fits me needs?

  
   
   
   
Thursday, February 15, 2007 1:05:49 AM (US Mountain Standard Time, UTC-07:00)
This is not a solution but another problem i am facing
with the same scenario

1. I need to perform the database migration testing

Old database is MySQL and New Database SQL Server

Please can any one tell us the tool which supports the above criteria
sats
Sunday, February 18, 2007 9:02:08 AM (US Mountain Standard Time, UTC-07:00)
I believe Red Gate's SQL Data Compare meets your second requirement. It's been a while since I've used it, but, at my last gig we used SQL Compare and Data Compare to figure out all the changes that needed to go into our upgrade scripts.
Steve
Sunday, February 18, 2007 4:52:20 PM (US Mountain Standard Time, UTC-07:00)
You might also look at tools from Idera and Innovartis. I think they both have something that might do what you want.

Also I wrote a little tool called Scriptio to do SQL Server 2005 scripting. I think this will be improved with SP2. You can easily Google for Scripitio.
Bill Graziano
Saturday, March 10, 2007 10:14:09 PM (US Mountain Standard Time, UTC-07:00)
Hi, I've really enjoyed your blog :-) Just came across <a href="http://schemacrawler.sourceforge.net/">SchemaCrawler</a> and was reminded of this post - thought it might address your need.
Shawn
Comments are closed.

Search QAInsight.net
Subscribe!
RSS 2.0All of QAInsight.net
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

My Testing Tools
Brent's Web Testing Toolbox
User-Agent Info and Tools

QA Blogs
 Bug Bash
 James Bach
 Josh Poley
 Rosie Sherry
 Test Early
 Testing Reflections
 The Braidy Tester
Other, Favorite Blogs
 Alex Scoble
 CopyBlogger
 Greg Hughes
 Jeff AtWood
 Lidor Wyssocky
 Matt Lapworth
 Milind Pandit
 Phillip Forteza
 Rory Blyth
 Scott Hanselman
 Simon Goldstein

Profile
About Brent Strange
Send mail to the author(s)
E-mail
Instant Message
View Brent Strange's profile on LinkedIn

Blog Archive
 List all Posts
December, 2008 (2)
November, 2008 (2)
September, 2008 (7)
August, 2008 (1)
July, 2008 (3)
June, 2008 (1)
May, 2008 (2)
April, 2008 (9)
March, 2008 (14)
February, 2008 (8)
January, 2008 (13)
December, 2007 (8)
November, 2007 (4)
October, 2007 (14)
September, 2007 (11)
August, 2007 (4)
July, 2007 (1)
June, 2007 (4)
May, 2007 (10)
April, 2007 (7)
March, 2007 (6)
February, 2007 (11)
January, 2007 (19)
December, 2006 (6)
November, 2006 (5)
October, 2006 (22)
September, 2006 (12)
August, 2006 (16)
July, 2006 (12)
June, 2006 (19)
May, 2006 (18)
April, 2006 (23)
March, 2006 (27)
February, 2006 (16)
January, 2006 (21)
December, 2005 (14)
July, 2005 (2)

Legal Mumbo-Jumbo
The opinions expressed herein are not necessarily those of my employer, not necessarily mine, and probably not necessary.

Copyright 2009 Brent Strange
Driven by newtelligence dasBlog 2.0.7226.0