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.
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