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?
Automatic changes script generation
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.