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.