I obviously haven't been using it as long as you but I agree it seems to be a really good product. I don't especially like SQL DTS either and will probably abandon the use of it over time.
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom McNeer Sent: Friday, October 26, 2007 12:15 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: SQL Toolkit from Red Gate Hi Dusty, On 10/26/07, Dusty Hale <[EMAIL PROTECTED]> wrote: I could be mistaken but I think the Toolkit is just a bundle. No, you're right. I just hadn't explored enough to know whether the Toolkit might include other tools as well. 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. I don't know whether the older version I have simply doesn't have custom comparison keys, or whether I just don't know how/where to use them. Nevertheless, it sounds like you've gotten past the problem. 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?) ... Well, I'm not any kind of authority on DTS. I generally hated it because it was so opaque. The Red Gate tools actually generate SQL you can read, if necessary, edit and run on your own. Basically, I just think Red Gate's stuff is just good. -- 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 -------------------------------------------------------------