List:General Discussion« Previous MessageNext Message »
From:Markus Grossrieder Date:August 10 2008 12:46pm
Subject:Re: Transplanting table structure changes
View as plain text  
Hi Jerry,

there's a (commercial) product called SQLyog, with an excellent schema 
synchronization tool (at least in the enterprise version) which procudes 
ready-made "alter table" scripts.

Probably other db tools have this functionality too ...

HTH, regards,

----- Original Message ----- 
From: "Jerry Schwartz" <jschwartz@stripped>
To: "'Martijn Tonies'" <m.tonies@stripped>; <mysql@stripped>
Sent: Friday, August 08, 2008 8:44 PM
Subject: RE: Transplanting table structure changes

> >You might want to try our Schema Compare tool inside Database Workbench.
>>This tool also has a "script recorder" that can record any changes you
>>to (meta)data in order to help you keep your change scripts.
> [JS] Ah! I just discovered that if I hit what looks like the "record"
> button, I get a script that is just the ALTER TABLE DDL that I need. I
> thought I was going to have to record my own.
>>Martijn Tonies
>>Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,
>>Oracle &
>>MS SQL Server
>>Upscene Productions
>>My thoughts:
>>Database development questions? Check the forum!
>>MySQL General Mailing List
>>For list archives:
>>To unsubscribe:
> -- 
> MySQL General Mailing List
> For list archives:
> To unsubscribe: 
> No virus found in this incoming message.
> Checked by AVG -
> Version: 8.0.138 / Virus Database: 270.6.0/1601 - Release Date: 8/8/2008 
> 9:02 AM

Transplanting table structure changesJerry Schwartz6 Aug
  • Re: Transplanting table structure changesGlyn Astill6 Aug
  • Re: Transplanting table structure changesMartijn Tonies7 Aug
    • RE: Transplanting table structure changesJerry Schwartz8 Aug
    • RE: Transplanting table structure changesJerry Schwartz8 Aug
  • Re: Transplanting table structure changesMarkus Grossrieder10 Aug
    • RE: Transplanting table structure changesJerry Schwartz11 Aug
  • Re: Transplanting table structure changesMartijn Tonies11 Aug