The Data Comparison plugin of Data Utensil allows you to compare two schemas. Once the comparison is complete, you can see whether a pair of tables are identical, have different columns, are new or…

Partho Sarathi
Working with databases: schemas, aggregates, and storing GUIDs in Firebird and MySQL.
The Data Comparison plugin of Data Utensil allows you to compare two schemas. Once the comparison is complete, you can see whether a pair of tables are identical, have different columns, are new or…

Partho Sarathi
A handy feature of Data Utensil is that you can apply aggregate functions (such as Count, Max, Min, Sum, Avg, etc) on a table by right clicking on the column header of the Table Data View .

Partho Sarathi
This post briefly explains the different views available for Managing a Table’s definition using Data Utensil .

Partho Sarathi
Use the CHAR data type with a size of 16 and the OCTETS character set. This saves the value in binary, thus saving a few bytes.

Partho Sarathi
Use the BINARY data type with a size of 16 . This saves the value in binary, thus saving a few bytes.

Partho Sarathi
Monitoring, conversion tools and more, built by the same people who wrote these posts.