Metadata changes log - new feature needed

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
mariusz
Posts: 62
Joined: Wed 16 Jul 2008 21:04
Location: Poland / Poznan
Contact:

Metadata changes log - new feature needed

Post by mariusz » Tue 19 May 2009 23:35

I am usually working on local mySQL server with local database. When I have my work finished I need a sql script with metadata changes to execute on production server. I know, I can copy data from "SQl log", but when I forgot do this, all data are lost. There should be a checkbox to turn on/off logging and saving log file to disk.

It shouldn't be difficult but very usefull.

This, or possibilities to append last queries to sql file. I am executing query, and instead of overwrite existing file, I'd like to append last queries to this existing file.

Duke
Devart Team
Posts: 476
Joined: Fri 29 Oct 2004 09:25

Post by Duke » Wed 20 May 2009 08:27

You can use Schema/Data Comparison tools for synchronization with production server.

Duke
Devart Team
Posts: 476
Joined: Fri 29 Oct 2004 09:25

Post by Duke » Fri 22 May 2009 08:24

For more information see article The Basics of Qualitative Schema Comparison here
http://www.devart.com/dbforge/mysql/stu ... rison.html

Post Reply