I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 218, comments - 2281, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

SQL Server 2005: TableDiff.exe GUI

Some time ago i've written about the TableDiff.exe utility. It's a great tool for quick table comparisons and i've grown tired of typing it in the command line.

That's why I created this simple TableDiff GUI to help me along and i've decided to share it with the world. :)

 

You can download it here.

 

Hope you find it usefull.

 

kick it on DotNetKicks.com

Print | posted on Friday, August 10, 2007 11:58 AM | Filed Under [ SQL Server ]

Feedback

Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Screenshot would be nice! :)
8/13/2007 4:55 PM | David
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Take a look at this url http://devintelligence.com/blogs/netadventures/archive/2007/08/13/ui-for-ms-sql-server-tablediff-tool.aspx to see the screenshot .
8/13/2007 10:02 PM | .Net Adventures
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Where's the source code?
8/14/2007 7:47 PM | Chris Pietschmann
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

i didn't post the source code.
you can use reflector to see it.
8/14/2007 7:50 PM | Mladen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Thanks ! Very useful :)
8/15/2007 11:20 AM | Dan
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

The webpage shows "Server Error in '/' Application.", and the GUI exe never shows a GUI.
8/16/2007 4:08 PM | Bill
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

emm... what are you talking about, Bill?

what webpage?
8/16/2007 5:10 PM | Mladen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Great job! Thanks for sharing :-)
8/16/2007 7:36 PM | Normajean
Gravatar

# Great Utility, Thanks for posting

Thanks for posting this valuable tool. It is always nice to have a GUI wrapper for command line tools with a lot of powerful options!
8/21/2007 4:16 PM | Michael David Austin
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Thanks for the tool, works like a charm. This is a good way to transfer data between databases on different servers, such as qa to prod, where typically you cannot link them due to network restrictions.
8/30/2007 4:11 PM | Just Don't Know
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

glad you like it!
8/30/2007 4:12 PM | Mladen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Will this work on SQL 2000?

Jen
8/30/2007 10:59 PM | Jen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

since tablediff.exe works on 2000 this will too :)
how ever tablediff.exe comes with sql server 2005.
8/30/2007 11:04 PM | Mladen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Just curious...what needs to be done in regards to get this to work...I have both the tablediff.exe and the tablediffGUI.exe on my computer and am attempting to connect to a server...each time I try to connect either via the SA or via Win Auth I get a failed to connect message...

It would be a little helpful to know some of the workings and how this tries to connect...

Do you need a DSN or anything to connect to the server? does something on the server need to be enabled?

Also a little constructive criticism...it doesn't appear to be any error handling in regards to blank fields...the couple of times I messed around with this it still allowed you to run the tablediff even if you didn't have all the fields entered which basically had my machine locked up...

Looks like a great tool I just wish I could get it to work !!!
11/2/2007 5:35 PM | Lee
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

well you have to tell the gui where the tablediff.exe is.
also try running it on the servers since tablediff.exe was never meant
to be run on the client.

i've added only most basic error handling to blank fields
what gui does is simply build the cmd string and runs the tablediff.exe
11/2/2007 5:41 PM | Mladen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

ah...ok I will have to get the server up to the correct version of .NET as it is calling for v2...

I will give that a try
11/2/2007 6:34 PM | Lee
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

What's with all the abrupt comments ! Efforts appreciated sir
11/7/2007 10:28 PM | Bigpa
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Greetings.

The gui applications looks like a good easy way to go however i am having a few problems.

The gui comes up and allows me to enter connection info but i get the following message on attempting to connect.

"Failed to retrieve data for this request."

The connection info is correct as far as i can tell and i can connect to the db through server manager.

any clues suggestions etc...

thanks

Peter
1/10/2008 12:24 AM | Peter Brighton
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Oh so sweet. Nice job.
1/11/2008 8:58 PM | NFG
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Thank you for this. great job!
1/31/2008 6:26 PM | AJ
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Thanks n really a gr8 work, but i am not able to generate the SQL Syn Scripts using the tool (even i hav tried in command prompt). Can any one help me out in generating the differential scripts using this tool? reply asap...
2/6/2008 8:08 AM | Karthikeyan Kannan
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

How do you specify an alternate port in TableDiffGui ?
2/26/2008 10:21 PM | jeff
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

OK, what id I have a bunch of tables .... how can we work abt it ...
3/5/2008 4:27 AM | fakeDBA
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

what about omitting a unique column, theres no way to omit columns and compare the rest. I have a date column on my 2 tables and when i compare both it says every row is deifferent because both tabels have a diffent date yet the data in the other columns are identical. If i could only be able to omit the date columns and compare the rest this would work better.
4/14/2008 10:39 PM | jay
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Where can I download tablediff.exe?
4/22/2008 11:26 AM | pippo
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

tablediff.exe is a tool that comes with sql server. it's also installed on the server.
it can't be downloaded by itself.
4/22/2008 11:40 AM | Mladen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

I installed SQL server 2005, and SP2, but I have not tablediff.exe in my server.
Where can I find it?
4/22/2008 11:58 AM | pippo
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

"C:\Program Files\Microsoft SQL Server\90\COM\TableDiff.exe"
or in another directory than the C:\Program Files\ depending on your install path

i don't know if it comes with the sql server express version.
4/22/2008 1:26 PM | Mladen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

My laptop with SQL Server Express has tablediff.exe
5/3/2008 7:39 PM | Rob Bohn
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

I've found this tool and think it will be useful for me, but I didn't succeed to run it. I have Sql2000 on my Development Server W2k3, and tablediff.exe runs well from command line, but tablediffgui.exe won't. After specifying the path for tablediff.exe I try to connect to my LOCAL (same machine) instance, using both Win auth and Sql Auth, trying specify instance name on gui, or also adding a 'Client Network Alias', but I always get the message 'Failed to retrieve data for this request.'.
What I'm doing wrong? I can't understand.
TIA
Luigi
5/5/2008 11:48 AM | Luigi VISINTIN
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Mladen
This is a fantastic little tool thanks.
I only wish it could compare SQL against microsoft access as well it would save me a whole load of hassle.
Thanks again
Martin
5/9/2008 9:53 PM | Martin
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

It is really helpful utility... I winder if any one create SP to use this to insert the result into table and then script it so script can be run on the destination DB.... It will be very handy and useful to save valuable Time of DBA.

Thanks in Advance
5/22/2008 9:57 AM | sonny
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Well played Sir, this is brilliant!
7/18/2008 4:59 PM | Nick
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Is there a way to run it for all tables especially when the replication transactional from publisher to subscriber is not in sync.
So i can then just run this to update the subscription tables with the necessary data.
9/12/2008 6:30 PM | tracey
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

great tool... will this tool detect if data has changed between two database table that use different collation? we are converting a database from one latin collation to the the sql server default latin collation and i want ot ensure no data is different in the destination...

I am not looking for help doing the collation, we have that covered, just wondering if this tool/tablediif can do the data integrety checks.
10/16/2008 3:38 PM | Scott B
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

no clue. never tried that. try it on a test table and see :))
10/16/2008 3:53 PM | Mladen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

yep thats the plan. just wondering if you had seen it used in that manor before. Thanks
10/16/2008 4:44 PM | Scott B
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Hi, just a quick question here, this tool only compares tables between tables from sql 2k5 right? it can't compare between tables from previous versions of sql server to 2k5 right? Thanks.
10/21/2008 12:38 AM | Renato Marroquin
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

as far as i know i works on 2000 too. haven't tried it though.
10/21/2008 10:30 AM | Mladen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

This an excellent tool!

Could I suggest some enhancements?

1. A facility to select views aswell as tables. Our replication works by replicating to source tables that have an additional column (identifying the publisher), so a direct comparison of Source Table to Destination Table is not possible, but I can compare a Source View (that includes the additional column) with the Destination Table. If the GUI could do that then it would allow us to use it.

2. A facility to compare multiple views/tables.

Thanks.
11/7/2008 4:10 PM | Chris O'Donnell
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

hi,
i've stopped development of this a long while ago... if you want i can send you the source and you can change it by yourself.
11/7/2008 4:43 PM | Mladen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Thanks a bunch!
11/12/2008 10:51 PM | BeeradG
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Hi Mladen,

Thanks for such handy tool.

I have some similar requirements but I cannot use this tool as it is. I need to customize this tool to fit my requirements. Would it be possible for you to share source code for this tool?

Thanks,
Jignesh

11/14/2008 11:48 PM | Jignesh
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Great tool! Thx!
11/21/2008 1:52 PM | Dominik
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Very nice tool! Thanks for sharing.
11/28/2008 4:14 AM | Kevin Bailey
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Brilliant program. Thank you very much for making it available to all of us.

Kind regards,

Polly Anna
2/11/2009 12:16 PM | Polly Anna
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

good program, tq so much
2/15/2009 3:58 AM | zam
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Is there are way with the tablediff.exe or your tablediffgui.exe utilities that the insert/update/delete statements can be sent directly to a specified database table rather than the text file?

Thanks.
3/2/2009 9:35 PM | Keith Lunevich
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

don't think so.
3/2/2009 9:37 PM | Mladen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Thanks for sharing this helpful tool!
Great work by the way...
4/29/2009 5:18 PM | Jaime
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Great Tool!

This doesn't seem to work for SQL Server 2008.
Is that Correct?
5/11/2009 8:23 PM | Oran
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

i have no idea since i haven't really tried. but if the tablediff utility has changed then it won't work oherwise i don't know why it shouldn't.
5/12/2009 9:57 AM | Mladen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Where does it send the Output "TableName" if you are comparing across 2 DB's?
5/15/2009 5:36 PM | Jack Shaftoe
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

this is gr8! thank you so much for sharing it!
7/9/2009 10:01 AM | sql proggrammer
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Excellent, thank you for sharing this with everyone
7/16/2009 1:45 PM | Jude Pieries
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Thanks for a very handy tool - saved a heap of time syncing dbs.
One point - would it be possible to enlarge the Table Combo Boxes as many of the longer tables names get truncated and I can't tell if i've selected the right one.
Hopefully only a minor changes to the UI.
Thanks
Peter
ps. it does work with 2005 and 2008 as I am syncing from 2008 live back to 2005 dev - go figure, but it works great!
7/31/2009 5:56 AM | Peter
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Thanks!!!!! :-)

Excellent work!
Matteo
ps. i have try only with 2 different "sql server 2005" server.
8/13/2009 9:26 AM | Matteo
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Very useful tool, but doesn't works. Got the message "Failed to retrieve data for this request", trying with IP, name and alias of the server... :(
8/13/2009 11:34 AM | csm
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Excellent work....Thanks a lot for the explanatuion in the earlier post and making a GUI like this
10/14/2009 5:38 PM | Krishnaraj
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

When I clicked on the link above, my company's Web Security Gateway blocked it because it "contains malicious code." I then right-clicked on the link and was able to save the zip file to my machine, but WinZip gives me the following error when I try to open it:

Cannot open file: it does not appear to be a valid archive.

Any idea what could be wrong here? Thanks.
10/19/2009 8:23 PM | Robert
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

i have no lcue what could be the problem. i can download and extract it without problem.
10/19/2009 8:27 PM | Mladen
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Same problem as several other people here.
Can't connect to server even though the credentials are correct.
I am on SQL 7. I do have the tableDiff.exe though.
This sounds like a very useful tool if it worked.
Since you offered to send the code, can you send it to me please?
or a fixed version?
Anybody?
Thanks for sharing the fruit of your labor.
11/18/2009 5:47 PM | ILIA
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Nice little tool. It helps a lot to save time..
12/22/2009 10:08 PM | Hari
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

First comment in 2010 !! Cool Work !!!!
2/1/2010 2:03 PM | RamLal
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

This is a very useful tool. However, as a few before me, I would like to make a few changes for my own purposes. I notice you've kindly sent the source to other developers. Any chance you could send it to me. Thanks.
4/1/2010 11:39 AM | Kevin
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Hello, and thanks for the tool.

It fails to connect to SQL Server 2008 saying just "Failed to connect to server". My guess is, the tool uses SMO 9.0 that doesn't support SQL Server 2008.
Could you please recompile the tool against SMO for SQL Server 2008?
5/28/2010 2:34 PM | Vlad
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Hi Mladen,

I just discovered your tool and it's been really useful for me in order to fullfill my work over a clustered sql2005 enviroments.
I would really apreciate if you can share the source code with me to add some improvements based on customers requeriments.

Thanks for sharing!
Noël (Barcelona, Spain)
5/31/2010 12:48 PM | Noël
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

Hi,
Thanks for the tool. But it fails for SQL server 2008. Can you put a SQL 2008 version?

Thanks in advance,
Deepika
7/9/2010 8:58 PM | Deepika
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

I created a UI similar to this that does bulk processing using tablediff.exe.

You can find the source code and binary release here - http://code.google.com/p/sqltablediff/
7/16/2010 4:33 PM | Wayne Bloss
Gravatar

# re: SQL Server 2005: TableDiff.exe GUI

I tried it on a WinXP comparing a SQL2008 as the source and SQL2005 as the destination and i was able to compare find.

I have a problem running the applicatio on a Win7. The application doesn't load the SQL servers on the dropdowns and if you type them in, it still fails to connect.

Is the GUI not compatible with WIN7 running SQL2008?
7/29/2010 2:21 PM | nightvision
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET