The tool is called SQL Search and is provided by Redgate! The system tables for object names or sql text, but why not just download this free tool and simply click the SQL Search button that.

Joel is always talking about how great SQL Compare from Redgate software is. SQL Compare only works with Microsoft SQL Server databases, but is there a good piece of software that works with MySQL and the other common databases that are part of the LAMP stack (PostgreSQL, Oracle, etc)?

4 Answers

Red Gate now has MySQL Compare & MySQL Data Compare

you can use Toad for MySql , it has a compare features

Maatkit also support several different RDBMS

Winsql is a good windows application that uses odbc to connect to any db and has compare tools. Here's the address: http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp

Sure, this is an old thread, but it's much younger than MySQL.

I'm currently evaluating 'Navicat', which does schema and data synchronisation for the following databases: MySQL, MariaDB, SQL Server, SQLite, Oracle and PostgreSQL. It seems to be a bit cheaper that the Red-gate tools.

It also has some extra stuff: SSMS-like functionality (i.e. design tables, views etc.), data modelling - i.e. reverse engineering tables/relationships into an editable diagram. Doesn't seem to have DB source control.

P.S. - I have no affiliation to this company, or software - just checking it out. Seems to fit the bill.

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

Narrow Results

• By Price

• By Category

• By Operating System

• Web sitehttp://www.red-gate.com
• Support web sitehttp://www.red-gate.com/supportcenter

• Support e-mail support@red-gate.com
• Support phone 8667334283

• Enhance SQL Server Management Studio with intelligent auto-completion of SQL Queries.
  13,172

  21
• Explore, browse, and analyze .NET assemblies.
  74,476

  6
• Deploy databases using a single executable file.
  235

  3
• Optimize and protect your .NET code and software.
  6,268

  1
• Explore changes made with SQL Server and perform undos.
  3,081

  1
• Compare and synchronize SQL database structures, contents, and SQL servers.
  2,195

  1
• Compare and synchronize SQL Server database contents.
  534

  1
• Compare and synchronize SQL Server database schemas.
  1,012

  1
• Generate test data for SQL Server databases.
  1,035

  1
• performance & memory profiling for .NET
  1,430

  1
• Results 1 - 10 of 14