• SQLyog - http://www.webyog.com/ - SQLyog is a easy to use, compact and very fast graphical tool to manage your My'SQL database. Similar to MYSQL Front and even a little more powerful. See the above website for a full list of features. This program was freeware when I added it to this list, but has now gone Shareware. //mysqlfront.venturemedia.de - MySQL-Front is a free, powerful and easy-to-use Win32-Interface for web-workers dealing with MySQL-Databases. Not quite as powerful as SQLyog, but a little easier to use. With My'SQL-Front you can:
  • create/drop databases
  • create/drop tables
  • edit/add/delete fields
  • edit/insert/delete records
  • edit BLOBs and MEMOs with Bitmap/GIF/JPEG-Support
  • execute (large) SQL-scripts
  • export table-structure and data into SQL-scripts or other databases
  • replicate databases between two hosts (“Export tables…”)
  • save data to CSV-Files (ideal for working with MSHTML-tables
  • copy CSV-data/HTML-Tables to clipboard
  • copy tables to new table-names
  • manage users (new in 2.0: edit existing users)
  • write SQL-queries with syntax-highlighting
  • import data from ODBC-datasources
  • do table-diagnostics (check, optimize, repair, analyze)
  • and a lot more…

Note - this program is no longer supported by its author, but it can still be obtained from the above page by clicking the download link in the upper right corner. It doesn't seem to work correctly on Windows NT, but does work on most other Windows versions.

• CSVdb - http://home.hccnet.nl/s.j.francke/t2t/text2table.htm - CSVdb is a little utility for viewing, editing or rearranging data or columns in a comma delimited (or any other delimiter) text file. If you're trying to transfer data from another library system to Koha via a delimited text file, this utility can help.

Back to « KohaOnWindows