|
Comments
|
Dexter Jones on
12/16/2009
Thanks for pointing out this useful tool.
Curiously, I did find it on my machine in the 90 (2005) folder, but not in the 100 (2008) folder. Does it only get installed when Replication is installed?
|
|
|
Very handy if you don't have money to afford Redgate's SQL Data Compare
|
|
Darren Bates on
12/16/2009
nice intro to a tool I wasn't aware of
|
|
|
That is pretty cool!
|
|
Darren Bates on
12/16/2009
good quick summary, BUT the diff_script.bat file WAS NOT REVEALED! So the example can't be duplicated as displayed!
|
|
RangeValidator on
12/16/2009
Very nice. Very useful.
|
|
Art Sennholtz on
12/16/2009
Would have liked to know if it sync'ed individual fields.
|
|
|
very nice. thank you very much
|
|
Don Weigend on
12/16/2009
Tablediff will really come in handy, thanks for the tip.
|
|
Richard Ray on
12/16/2009
I weep with gratitude. I was just about to embark on writing this tools, probably not nearly as well as it's delivered for free. And for free...
|
|
|
The only issue with this tool is that it cannot be used if the schemas of the table are slightly different in case of replicating databases used for reports
|
|
|
Never heard of this command line tool before but will be hughly useful in my work place.
|
|
|
Did not see the differences captured. Needed a little more explaination.
|
|
|
It is not installed in my SQL Server 2008 Developer edition. Anybody know what component needs to be installed?
|
|
|
What this video didn't answer is, what versions of SQL Server is Tablediff available for.
|
|
|
Wish I'd have seen this before!
|
|
|
Works great! One note: Depending on which table is the first table you will get INSERT. If you flip the tables you will GET DELETE. That is how you sync them.
|
|
|
Should have shown example with matching, add, update and delete.
|
|
|
a good pointer to some of tablediff's functionality
|
|
Jeromy Kimani on
12/16/2009
Did not have enough information about the tool & how to get it.
|
|
|
very good
Rinkal Ror
|
|
Anthony Henley on
12/16/2009
Wish it could a quick compare and what the output looks like.
|
|
|
good
|
|
|
Muito bom!
|
|
Steve Culshaw on
12/17/2009
Neat utility, especially when you consider the cost of some of the commercial ones out there
|
|
|
A great introduction to this little known utility and certainly one I'll be looking into further.
|
|
Jack Hellmuth on
12/17/2009
importanly, but not discussed, is how 2 tables are made the same. The example showed only a simple case. What is the two tables both have a row that is similar in some columns and not others. What happens?
|
|
Kris Robinett on
12/17/2009
Good to inform that tablediff exists - does not show much on how it works or how to use it/what parameters mean.
|
|
|
?
|
|
|
A place to get the scripts would be nice
|
|
|
Finding out about tablediff was cool, but this just barely scratched the surface. It wasn't nearly as much information as I usually get from these videos.
|
|
Sam Schafer on
12/17/2009
Great tip! Can't wait to try it out!
|
|
|
Thanks for sharing! This is the first time I have heard of this tool. Any others out there?
|
|
|
It is good to know. Thanks
|
|
R Michael Lacy on
12/21/2009
Please attach the executable used in the video.
|
|
|
The attached batch file would have been nice, But as i said before don't just use a feature becasue it is there. There are some things you need to know about this feature before you start uding it that the speaker dod not cover. Please check out the following link for more complete info on this utility: http://msdn.microsoft.com/en-us/library/ms162843.aspx
|
|
|
This is good to see, but can you not do this with an SSIS package too?
|
|
|
Could have used a little more explanation or examples of how this utility can be helpful. Nice find though.
|
|
|
thanks, it was usefull
|
|
|
could not find this file in the mentioned folder. Does this require any additional installs?
|
|
mengchew0113 on
5/17/2010
thanks for sharing. it very useful
|
|
|
good article to learn tablediff utility
|
|
|
Good pointer to a useful FREE tool
|
|
|
Nice one
|
|
|
can we have the script which is written by the speaker?
|
|
|
Nice article
|
|
|
Is it Russian accent?))) Anyway, thanks for the lesson!
|
|
|
A good quick tip. very usefull to know
|
|
|
Very Useful
|
|
|
good to know...but it was too quick for me. Maybe include some examples of what the output looks like?
|
|
|
I would have like to have seen update and delete operations as well.
|
|
|
I learned something new, thanks
|
|
|
Would have liked to see a little more information on the tool.
|
|
|
Free is good...
|
|
|
I've been working with SQL Server for years and I didn't know about this tool. Thanks.
|
|
|
Would have liked an explanation of the parameters that are available. Maybe that is in another video
|
|
|
Interesting command but he didn't show any results from comparing the tables
|
|
|
Should have stated this tool is available only to server Windows administrators and not necessarily DBA's, and certainly not to SQL developers.
|
|
|
OMG! VERY valuable 2 minutes! Did not know about this!
|
|
|
Maybe there'll be more about this in an upcoming video; if so please mention that "... in a future video we will cover..." If there isn't, what about performance concerns? Situations where you've used tablediff? What happens if the schemas aren't quite the same? Last time I wrote a comment, the topic was covered in a different video so that's why I'm suggesting that you mention that you'll cover additional ground if that is the case. Thanks, love the content - keep it going!
|
|
|
Not clear at all. But I'll give it a go.
|
|
|
Can you show more real world examples what you could use this for.
|
|
|
is this available for use with SQL Server 2005 ?
|
|
|
The presentation was too short and needed a demonstation on how to find and create the cmd line.
|
|
|
Not the best explained video.
|
|
|
Tablediff is good to know. Your video was good intro to it. Thanks.
|
|
|
very handy
|
|
|
This was helpful. I could have used more detail about how to use the results.
|
|
|
I had no idea that tablediff even existed!
|
|
|
Great tool to learn about and to have. Thanks for bringing it to my attention.
|
|
|
tablediff was not in my COM folder. Is there somewhere else it could be located?
|
|
|
I had to install the Replication components before it it showed up. I'm running Express with Adv Services.
|
|
|
It is a very useful tool, but from the video the explanation of the parameters and their usage are missing.
|
|
|
This seems like a good tool to sync test and train environments with production data. Is there a limit to the amount of data that can be different?
Does it script changes both ways?
|
|
|
Good tip.
|
|
Maurice Ivory on
3/11/2011
Did get much out of this video...
|
|
|
Very cool feature. Thanks for sharing.
|
|
|
Screen font too small. Seems like a useful tip tho.
|
|
|
wonderful, cannot believe these hidden utilities lying under my desk.
|
|
|
This is pretty interesting and I didn't know it existed but I think you need to explain it a little better. Step by step with more detail. Thanks!
|
|
Steve Harris on
3/23/2011
does it also do updates?
|
|
James Moore on
10/26/2011
Good job!
|
|
|
tablediff , often overlooked utility
|