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,
Markus

----- 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
>>make
>>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
>>http://www.upscene.com
>>My thoughts:
>>http://blog.upscene.com/martijn/
>>Database development questions? Check the forum!
>>http://www.databasedevelopmentforum.com
>>
>>
>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>>infoshop.com
>
>
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: 
> http://lists.mysql.com/mysql?unsub=1
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.138 / Virus Database: 270.6.0/1601 - Release Date: 8/8/2008 
> 9:02 AM
>
>
> 

Thread
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