Sponsored By Aspose - File Format APIs for .NET

Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!

Red Gate’s SQL Bundle is worth every penny

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.

This entry was posted in Uncategorized. Bookmark the permalink. Follow any comments here with the RSS feed for this post.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>