SQLDBDiff is a powerful and intuitive tool that compares the schema and the data of SQL Server databases. SQLDBDiff supports SQL Server Version 2005 to 2019, SQL Azure and SQL on Linux.

SQLDBDiffConsole.exe is the console version of SQLDBDiff, the line command has the following syntax :

1. MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.
2. SQL DXP is SQL Delta Cross Platform, a cross platform database compare tool for comparing databases across different server platforms such as SQL Server and MySQL or Oracle and MySQL. We also have the Premium version of DXP to access all three database servers.

SQLDBDiffConsole ServerName1 DBName1 User1 Password1 AuthWin1 ServerName2 DBName2 User2 Password2 AuthWin2 [OutputFile.txt]

SQL Saturday Speaker I had been seriously thinking of quitting the SQL space altogether and decided to get into other things, but this has got to be a great addition to becoming a better DBA. And in combination with the free, open source DBDoc for SQL Server, you have a full suite of documentation tools. In order to create a diagram showing tables, columns and relationships for your.

SQLDBDiff Freeware version is completely free without any evaluation period, this is my small contribution to SQL Server community.

By Ordering SQLDBDiff Shareware version, you'll get access to more advanced features, free upcoming updates and technical support by e-mail

SQLDBDifffeatures:

- Compare the structure of two SQL Server databases

Azure Sql Db Migration Tool

The following objects are supported:

• Tables and columns (with the possibility to respect or not columns order);
• Views (including their indexes and triggers);
• Stored procedures;
• User defined functions;
• Triggers;
• PK and Indexes (with the possibility to include or not statistic indexes);
• Relationships (FK);
• CHECK Constraints;
• Default Constraints;
• User Defined Data Type & User Defined Table Type
• DDL Triggers;
• Synonyms;
• In-Memory table
• System versioning (Temporal type)
• Permissions;
• User and Roles;
• Database properties;
• SQL Server properties.

-Generate schema synchronization scripts.

-Generate a schema difference report.

- Search an object by its name or content (text).

-Compare many databases to the same master database in one step. With SQLDBDiff you cannot only compare two databases, but many databases to the same master database, you can save the list in XML file and avoid manual input.

-Compare databases contents With SQLDBDiff you can compare tables even if they have different schemas or the primary key is missing. You can choose grid mode or text mode, in this last case you can:

• Select columns to be compared;
• Define a maximum of rows;
• Add WHERE or ORDER BY clause.

Sql Db Compare Tool

-Generate data synchronization scripts.

-Export database schema in flat file so you can import in your version-control software

Supported versions : SQL Server 2005 to 2019, SQL Azure and SQL on Linux

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.

Design

MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.
Learn More »

Develop

MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. The Database Connections Panel enables developers to easily manage standard database connections, including MySQL Fabric. The Object Browser provides instant access to database schema and objects.
Learn more »

Administer

MySQL Workbench provides a visual console to easily administer MySQL environments and gain better visibility into databases. Developers and DBAs can use the visual tools for configuring servers, administering users, performing backup and recovery, inspecting audit data, and viewing database health.
Learn more »

Visual Performance Dashboard

MySQL Workbench provides a suite of tools to improve the performance of MySQL applications. DBAs can quickly view key performance indicators using the Performance Dashboard. Performance Reports provide easy identification and access to IO hotspots, high cost SQL statements, and more. Plus, with 1 click, developers can see where to optimize their query with the improved and easy to use Visual Explain Plan.
Learn More »

Database Migration

MySQL Workbench now provides a complete, easy to use solution for migrating Microsoft SQL Server, Microsoft Access, Sybase ASE, PostreSQL, and other RDBMS tables, objects and data to MySQL. Developers and DBAs can quickly and easily convert existing applications to run on MySQL both on Windows and other platforms. Migration also supports migrating from earlier versions of MySQL to the latest releases.
Learn more »

Additional Resources