List:General Discussion« Previous MessageNext Message »
From:Insanely Great Date:February 8 2003 3:17pm
Subject:Re: Is there a SQL/diff program out there?
View as plain text  
Hello

The latest version of SQLyog at http://www.webyog.com/sqlyog/download.html
contains a very powerful diff tool and it is free.
Try it out.

Insane

----- Original Message -----
From: "Daevid Vincent" <daevid@stripped>
To: <mysql@stripped>
Sent: Friday, February 07, 2003 6:58 AM
Subject: Is there a SQL/diff program out there?


> I searched google, but didn't find anything.
>
> SYNOPSIS:
>
> Wondering if anyone knows of, or has built, or is interested in building
> a program that will take two .sql schema dumps (one new and one old) and
> create the ALTER / CREATE TABLE syntax to make the old one look like the
> new one. It should work in such a way that it doesn't matter if the
> table's schema are in the same order or not.
>
> REASON:
>
> We do a lot of development on our dev server and this involves creating
> new fields in the databases and even new tables. We have to manually go
> through using a script and update all the 'live' databases then so they
> jive with our dev environment. It's quite tedious to remember all that's
> changed and manually make the 'alter table' syntax ourselves.
>
> I'm surprised this isn't a more common tool request and it doesn't exist
> already -- at least none that I can find. There are ten million mySQL
> graphical clients out there, you'd think one of them would have such a
> useful feature.
>
> Is this something that people would want/use? If so, I'll build it. I
> just didn't want to spend the time/energy if it existed already
> somewhere.
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread131801@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-insanely420=punkass.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

Thread
Is there a SQL/diff program out there?Daevid Vincent7 Feb
  • Re: Is there a SQL/diff program out there?Insanely Great8 Feb
  • RE: Is there a SQL/diff program out there?Sherzod Ruzmetov8 Feb
  • Re: Is there a SQL/diff program out there?Zak Greant8 Feb
Re: Is there a SQL/diff program out there?Karam Chand9 Feb
  • RE: Is there a SQL/diff program out there?Lance Lovette12 Feb