October 28, 2008 at 5:22 am
Has anybody used it?
How does it compare to Redgate SQL Toolbelt? (Obviously the Database version) 😀
Does Redgate have an official comment?
Hiding under a desk from SSIS Implemenation Work :crazy:
October 28, 2008 at 6:27 am
Totally different toolsets to a large degree. Actually I use both together. I do use SQL Compare & SQL Data Compare a little less than I used to, but I find the SQL Data Generator from Red Gate a bit better, so I use that instead of the data generator in Visual Studio.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 28, 2008 at 6:53 am
Thanks Grant.
I was specifically talking about;
Database synch
Database Compare
Data Generator
Comparisons.
Hiding under a desk from SSIS Implemenation Work :crazy:
October 28, 2008 at 7:49 am
Shaun McGuile (10/28/2008)
Thanks Grant.I was specifically talking about;
Database synch
Database Compare
Data Generator
Comparisons.
Are you talking about TFS Database (or DataDude?) vs Red Gate?
Personally I like Red Gate tools better, period
I have used SQL Compare (sync and schema compare tool)
Loved it, much better and easier to use than TFS (last I tried in recent months, it doesn't support SQL2008 yet where RedGate does)
Data Compare is cool as well, I probably won't use it for MASS data movement, but quick small data are perfect
Data Generator I don't know much about though, as we usually have good test data already
October 28, 2008 at 8:16 am
Shaun McGuile (10/28/2008)
Thanks Grant.I was specifically talking about;
Database synch
Database Compare
Data Generator
Comparisons.
SQL Compare has quite a bit more functionality than the Schema Compare tool in VSTSDBE. But, the new version coming out (the GDR release) closes that gap quite a bit. However, I do find that, despite the shortcomings in functionality (inability to save settings between compares makes me insane), I do use the VSTSDBE Schema Compare a lot more because it's right there when I'm working. Why switch to another tool.
Data Generator from Red Gate is just flat out, a lot better. I like it's ability to pull data from other tables. Although that capability is there in VSTSDBE, it just isn't as good. Data Generator is easier to use, easier to maintain and I think, although this is a feeling, not tested, it's faster too.
I almost never use the Data compare utility in VSTSDBE. It's just not a normal part of the development cycle. So, when I need to do a data compare, I go to the Red Gate tool.
From my point of view, Red Gate has the edge for 2 out of the 3 you mentioned in terms of use, but it's 3 for 3 in straight functionality.
I'm pretty happy with both toolsets. At this point, I wouldn't get rid of one in favor of the other. However, if forced to choose, I'd reluctantly go with the Microsoft tools just because the other aspects of VSTSDBE are too good to pass up.
I'm presenting a session on deploying to multiple environments using VSTSDBE at PASS this year. My first time. If you're attending, swing by (I need attendees, they scheduled me at the same time as Gert Drapers. I'd almost rather go to his presentation than my own).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 28, 2008 at 9:40 am
PASS attendance now theres something I want to do but....
do not think I can do that, given the current ecconomic conditions.
I'd heckel from the front row no problem! 😀
--Shaun
Hiding under a desk from SSIS Implemenation Work :crazy:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply