RE: [ACFUG Discuss] OT: SQL Toolkit from Red Gate
That's what Red Gate does but it only works for MS SQL. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lance Knight Sent: Tuesday, October 30, 2007 3:16 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: SQL Toolkit from Red Gate This looks interesting , I'm looking for a tool to compare two mysql databases and create an update script. Lance From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Tuesday, October 30, 2007 4:02 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: SQL Toolkit from Red Gate I'll quote myself... lol On 10/26/07, Steven Ross [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: while we are talking cheap... what does navicat give you that the mysql admin tools don't? just curious... On 10/28/07, Tom McNeer [EMAIL PROTECTED] wrote: I've only followed this discussion briefly since my earlier post, but I wonder if other posters are really familiar with what the Red Gate tools do? I've used some of the other tools mentioned - Navicat, MySQL Admin, certainly Enterprise Manager -- and I currently use Aqua Data Studio for most tasks. But as far as I know, the Red Gate tools do lots of things those others can't. And remember, Dusty is specifically looking for something to use with MSSQL. -- 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 - -- Steven Ross web application interface developer http://blog.stevensross.com [mobile] 404-488-4364 [fax] 267-482-4364 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] - 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 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 -
Re: [ACFUG Discuss] OT: SQL Toolkit from Red Gate
I'll quote myself... lol On 10/26/07, Steven Ross [EMAIL PROTECTED] wrote: while we are talking cheap... what does navicat give you that the mysql admin tools don't? just curious... On 10/28/07, Tom McNeer [EMAIL PROTECTED] wrote: I've only followed this discussion briefly since my earlier post, but I wonder if other posters are really familiar with what the Red Gate tools do? I've used some of the other tools mentioned - Navicat, MySQL Admin, certainly Enterprise Manager -- and I currently use Aqua Data Studio for most tasks. But as far as I know, the Red Gate tools do lots of things those others can't. And remember, Dusty is specifically looking for something to use with MSSQL. -- 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 - -- Steven Ross web application interface developer http://blog.stevensross.com [mobile] 404-488-4364 [fax] 267-482-4364 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] - 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 -
Re: [ACFUG Discuss] OT: SQL Toolkit from Red Gate
I've only followed this discussion briefly since my earlier post, but I wonder if other posters are really familiar with what the Red Gate tools do? I've used some of the other tools mentioned - Navicat, MySQL Admin, certainly Enterprise Manager -- and I currently use Aqua Data Studio for most tasks. But as far as I know, the Red Gate tools do lots of things those others can't. And remember, Dusty is specifically looking for something to use with MSSQL. -- 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 http://www.fusionlink.com -
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 http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: SQL Toolkit from Red Gate
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 -
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 http://www.fusionlink.com -
Re: [ACFUG Discuss] OT: SQL Toolkit from Red Gate
Seems like a few years back that MySQL admin tools just administered the server, not the tables and data and such, but maybe it has changed since back then. Even with MySQL admin tools you had to use something like phpMyAdmin to create databases, tables and such. I purchased Navicat for it's drag-n-drop WYSIWYG SQL design feature, which I needed back when I was new to SQL. So now I just keep using it and I still find it's more efficient and easier to use than anything else I've tried. It's well worth the money to me. Between using phpMyAdmin and Navicat I found and used SQLyog for a while, really cool, was free, and still used by some developers I know. Steven Ross [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/26/2007 02:47 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] OT: SQL Toolkit from Red Gate while we are talking cheap... what does navicat give you that the mysql admin tools don't? just curious... On 10/26/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Wow, expensive. I'm not a DBA and don't have to do high-end DBMS and now I'm glad I don't need it. I just use Navicat ($100) for MySQL stuff and MS SQL Server tools (free) for MSSQL stuff. I've never found need for anything more and I can easily do compares, synchronization, import/export, queries, and so on. What kind of high-end DB activities is worth this price tag I can't get out of my tools? Dusty Hale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/26/2007 10:23 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] OT: SQL Toolkit from Red Gate Has anyone ever used this product? I downloaded the trial and it seems like a really slick tool and much easier to use than the DTS tools in enterprise manager. Just curious if anyone has an opinion about the product? http://www.red-gate.com/ Dusty - Annual Sponsor - Figleaf Software 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 - - Annual Sponsor - Figleaf Software 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 - -- Steven Ross web application interface developer http://blog.stevensross.com [mobile] 404-488-4364 [fax] 267-482-4364 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] - 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 - - 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 -
Re: [ACFUG Discuss] OT: SQL Toolkit from Red Gate
The mysql admin tools let you do just that, query browser and there is a table / db creator, even a migration tool, all free. On 10/26/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Seems like a few years back that MySQL admin tools just administered the server, not the tables and data and such, but maybe it has changed since back then. Even with MySQL admin tools you had to use something like phpMyAdmin to create databases, tables and such. I purchased Navicat for it's drag-n-drop WYSIWYG SQL design feature, which I needed back when I was new to SQL. So now I just keep using it and I still find it's more efficient and easier to use than anything else I've tried. It's well worth the money to me. Between using phpMyAdmin and Navicat I found and used SQLyog for a while, really cool, was free, and still used by some developers I know. Steven Ross [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/26/2007 02:47 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] OT: SQL Toolkit from Red Gate while we are talking cheap... what does navicat give you that the mysql admin tools don't? just curious... On 10/26/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Wow, expensive. I'm not a DBA and don't have to do high-end DBMS and now I'm glad I don't need it. I just use Navicat ($100) for MySQL stuff and MS SQL Server tools (free) for MSSQL stuff. I've never found need for anything more and I can easily do compares, synchronization, import/export, queries, and so on. What kind of high-end DB activities is worth this price tag I can't get out of my tools? Dusty Hale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/26/2007 10:23 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] OT: SQL Toolkit from Red Gate Has anyone ever used this product? I downloaded the trial and it seems like a really slick tool and much easier to use than the DTS tools in enterprise manager. Just curious if anyone has an opinion about the product? http://www.red-gate.com/ Dusty - Annual Sponsor - Figleaf Software 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 - - Annual Sponsor - Figleaf Software 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 - -- Steven Ross web application interface developer http://blog.stevensross.com [mobile] 404-488-4364 [fax] 267-482-4364 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] - 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 - - Annual Sponsor - Figleaf Software 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 - -- Steven Ross web application interface developer http://blog.stevensross.com [mobile] 404-488-4364 [fax] 267-482-4364 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] - 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 -