The following tables compare general and technical information for a number of available database administrator tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to date.

General[edit]

Features[edit]

Legend

• Create/alter table:
  • Yes - can create table, alter its definition and data, and add new rows
  • Some - can only create/alter table definition, not data
• Browse table:
  • Yes - can browse table definition and data
  • Some - can only browse table definition
• Multi-server support:
  • Yes - can manage from the same window/session multiple servers
  • Some - can manage from a different window/session multiple servers
• Monitoring server:
  • Yes - includes a headless server, that runs checks and reports failures

Features (continued)[edit]

Legend:

• User manager:
  • Yes - user manager with support for database and schema permissions as well as for individual object (table, view, functions) permissions
  • Some - simple user manager with support for database and schema permissions
  • No - no user manager, or read-only user manager

Features - visual design and reverse engineering[edit]

Legend:

• Visual schema/E-R design: the ability to draw entity-relationship diagrams for the database. If missing, the following two features will also be missing
• Reverse engineering - the ability to produce an ER diagram from a database, complete with foreign key relationships
  • Yes - supports incremental reverse engineering, preserving user modifications to the diagram and importing only changes from the database
  • Some - can only reverse engineer the entire database at once and drops any user modifications to the diagram (can't 'refresh' the diagram to match the database)
• Forward engineering - the ability to update the database schema with changes made to its entities and relationships via the ER diagram visual designer
  • Yes - can update user-selected entities
  • Some - can only update the entire database at once

See also[edit]

Notes[edit]

1. ^create CRUD interfaces, so create table data, not table theriselves.
2. ^Browse table data, not table definitions.
3. ^The CRUD interface created includes a search form.
4. ^Only incremental, by manually going through each table and clicking 'Add to graph'.
5. ^Generated SQL must be executed outside Toad Data Modeler.

References[edit]

1. ^https://www.adminer.org/
2. ^'Download SQL Server Management Studio (SSMS)'. 9 May 2018. Archived from the original on 14 May 2018.
3. ^https://bitbucket.org/phpliteadmin/public/downloads
4. ^'Security fix: phpMyAdmin 4.8.5 is released'. phpmyadmin.net. Retrieved 2019-01-26.
5. ^'blog.webyog.com/sqlyog-mysql-gui-12-4-3-released/'. Webyog.
6. ^Toad Data Modeler Betas
7. ^can manage its own users, which override the DBMS users
8. ^ ^abtitle= Navicat feature matrix
9. ^https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/21/source-control-in-sql-server-management-studio-ssms/
10. ^SQLYog query builder
11. ^SQLYog schema designer

External links[edit]

What is a free tool to compare two Sql Server tables (data and schema).

It would be great if the tool can script the differences found.

I also went through some older posts. The closest I have seen is SQLDBDiff but I would love to try more options.

closed as not constructive by KevFeb 25 '13 at 21:01

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.

7 Answers

TableDiff.exe should have everything you need. It is one of the hidden gems in SQL Server 2005. So you don't have to download anything.

• Table Difference tool allows you to discover and reconcile differences between a source and destination table or a view. Tablediff Utility can report differences on schema and data. The most popular feature of tablediff is the fact that it can generate a script that you can run on the destination that will reconcile differences between the tables. TableDiff.exe takes 2 sets of input;• Connectivity - Provide source and destination objects and connectivity information.

• Compare Options - Select one of the compare options• Compare schemas: Regular or Strict

• Compare using Rowcounts, Hashes or Column comparisons

• Generate difference scripts with I/U/D statements to synchronize destination to the source. TableDiff was intended for replication but can easily apply to any scenario where you need to compare data and schema.You can find more information about command line utilities and the Tablediff Utility in Books Online for SQL Server 2005.

Even though this has been answered years ago a new comer which works really well is Data Compare within Visual Studio. It is part of Visual Studio 2010 and is part of the Database Professionals GDR update to Visual Studio 2008. This works great when you want to compare the same tables in 2 different databases.

Gujarati comedy natak video. If you need to compare 2 tables with the same schema that are in the same database or with different names TableDiff (mentioned earlier) is a great option.

DBComparer is free and works well for MS SQL Server

We can recommend you a our reliable solutions for data and schema comparison for SQL Server: dbForge Schema Compare for SQL Server and dbForge Data Compare for SQL Server.

Ping a web site uses 'iNet' uses 'TcpUdp' uses 'Console' string sHost = 'www.thinbasic.com' string sIP = IP_ToString(HOSTNAME_TOIP(sHost)) string sData = 'abcdefghijklmnopqrstuvwxyz' string sPingBuffer printl 'Pinging', sHost, '[' + sIP + ']', 'with', len(sData), 'bytes od data:' while%TRUE sPingBuffer = INET_Ping(sHost, 1000, sData) '---All OK if val(parse$(sPingBuffer, $tab, 2)) = 0 Then printl time$, sPingBuffer in%CCOLOR_FLIGHTGREEN Else '---KO printl time$, sPingBuffer in%CCOLOR_FLIGHTRED end If sleep 1000 Wend. Basic programming language downloads.

Their main advantages are high speed (up to 3 times quicker than most competitors) and extreme reliability.

Those tools are not free, but you can use 30-days trial for free and you have an opportunity to get a free license for both of the products - please refer to our free license conditions page.

Atlantis Interactiv, now owned by Pragmatic Works has two free tools called Schema Inspector and Data Inspector that works very much like the Red Gates tools.

Try CompareData from Zidsoft. It's free for comparing table/view data and has 30-trial for metadata comparisons

A SQL Server specific database table diff tool is Volpet's Table Diff

Not the answer you're looking for? Browse other questions tagged sql-server or ask your own question.