This post originated from an RSS feed registered with .NET Buzz by Darrell Norton. Original Post: Red Gate's SQL Bundle is worth every penny Feed Title: Darrell Norton's Blog Feed URL: /error.htm?aspxerrorpath=/blogs/darrell.norton/Rss.aspx Feed Description: Agile Software Development: Scrum, XP, et al with .NET Latest .NET Buzz Posts Latest .NET Buzz Posts by Darrell Norton Latest Posts From Darrell Norton's Blog

My life is so much easier now. Why? I finally got work to purchase the SQL Bundle from red-gate software. SQL Bundle is just a combination of SQL Compare, SQL Data Compare, and DTS Compare, but for less money than buying just 2 of these products individually (only $350).

I do have a few missing features on my wish list already:

• Using Data Compare to synchronize all rows in a table is nice, but I’d like to be able to add a where clause to the filter. That way I could synchronize a few specific rows (you can do this manually by removing the INSERT lines of the records you don’t want, but that’s no fun).
• As an addition to the previous item, I would like to have an “ON CASCADE COPY” type of feature. If I want to copy an ORDER from the Northwind table, for example, it will copy all the ORDER ITEMS too (continuing on to related tables). That would be heavenly.
• More granular control over the comparison. Right now you can tell SQL Compare not to check foreign keys. I do want to check foreign keys but I don’t care whether the key is “ADD CONSTRAINT” or “WITH NOCHECK ADD CONSTRAINT” if everything else is the same.  Found it!
• A place on the web site to submit desired features.