Thursday, December 15, 2016

HeidiSQL is a very useful Open Source client to SQL Server

HeidiSQL is a very useful Open Source client to SQL Server


It is nice to have access to SQL Server from an Open Source program and HeidiSQL nicely comes in handy. It is free and Open Source. HeidiSQL can handle a surprisingly large number of tasks. Review this list:
•Connect to multiple servers in one window
•Connect to servers via command-line
•Connect via SSH tunnel, or pass SSL settings
•Create and edit tables, views, stored routines, triggers and scheduled events.
•Generate nice SQL-exports, compress these afterwards, or put them on the clipboard.
•Export from one server/database directly to another server/database
•Manage user-privileges
•Import text-files
•Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
•Browse and edit table-data using a comfortable grid
•Bulk edit tables (move to db, change engine, collation etc.)
•Batch-insert ASCII or binary files into tables
•Write queries with customizable syntax-highlighting and code-completion
•Pretty reformat disordered SQL
•Monitor and kill client-processes
•Find specific text in all tables of all databases of one server
•Optimize and repair tables in a batch manner
•Launch a parallel mysql.exe command line window using your current connection settings

In addition to Microsoft SQL Server you can also connect to PostgreSQL and MySQL. From the list above it can be seen that HeidiSQL can do things that SQL Server Management Studio cannot.

HeidiSQL may be downloaded from here by using any of the options.

Downloading and Installation is described ( from an installer) here in detail.

Connecting to SQL Server 2012 using HeidiSQL is described here.

Here is a named instance of SQL Server 2012 accessed on HeidiSQL.




Available link for download