I could be mistaken but I think the Toolkit is just a bundle. The trial had both the tools you mention (Compare, and Data Compare). After using it a few days, I think it rocks but just wanted to see if others thought the same about it or if anyone had run into problems with it. I had the same problem with the comparison keys at first but after I set up custom comparison keys within the tool it works fine. It seems superior to using DTS to me. I could be wrong here but setting up a DTS packet that compares and updates (rather than drop or delete data and replace) seems like a rather tedious task with DTS (maybe I'm missing something though?) ... Dusty
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom McNeer Sent: Friday, October 26, 2007 10:09 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: SQL Toolkit from Red Gate Dusty, I've never used SQL Toolkit, but I've used Red Gate's SQL Compare and SQL Data Compare tools for years. And they're terrific. The only issues I ever had involved synchronization, where there were problems because constraints were not properly dropped. But even that was a couple of versions back. In general, these guys make terrific tools and are actually accessible if you need help. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ------------------------------------------------------------- Annual Sponsor - Figleaf Software <http://www.figleaf.com> To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------