Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Automatic changes script generation

Stefano.matteuzzi's profile image Stefano.matteuzzi posted 2 weeks ago in General Permalink

hi, I am the team leader of a small Italian software house. We have migrated from mysql to maria db for about a year but still continue to use workbench. we wanted to change and switch to heidisql and trying it out, it really looks like a great product. However, I was unable to find the automatic script generation following the changes (both in the modification of the schema and in the modification of the data) that we use for the sql repository. can you tell me if this feature is present and how to activate it?

ansgar's profile image ansgar posted 2 weeks ago Permalink

You can activate logging your selected command types to a file:


That will produce such a logfile:

/* 2020-01-06 14:48:43 [] */ /* Writing to session log file now: C:\Users\becker\AppData\Roaming\HeidiSQL\Sessionlogs\000001.log */
/* 2020-01-06 14:49:04 [localhost] */ USE `test`;
/* 2020-01-06 14:49:05 [localhost] */ USE `temp`;
/* 2020-01-06 14:49:05 [localhost] */ SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='temp';
/* 2020-01-06 14:49:05 [localhost] */ SHOW TABLE STATUS FROM `temp`;
/* 2020-01-06 14:49:05 [localhost] */ SHOW FUNCTION STATUS WHERE `Db`='temp';
/* 2020-01-06 14:49:05 [localhost] */ SHOW PROCEDURE STATUS WHERE `Db`='temp';
/* 2020-01-06 14:49:05 [localhost] */ SHOW TRIGGERS FROM `temp`;

Please login to leave a reply, or register at first.