Get a grip on your data with JetBrain's DataGrip

DataGrip is an integrated IDE for all of your data needs.

DataGrip is the multi-engine database environment that supports the following:

 MySQL
 PostgreSQL
 Microsoft SQL Server
 Oracle, Sybase
 DB2
 SQLite
 HyperSQL
 Apache Derby
 H2

JDBC driver is necessary to connect to your database management system. For listed database engines DataGrip provides database introspection and various instruments for creating and modifying objects.

Main features:

It provides folders for the objects grouped by schemas
Navigation to any object is easy by entering database/table or procedure name
Table editor is powerful supported by text search
Intelligent coding assistance with code completion; code generation; renaming objects; code analysis with fixes; smart text editor; and support customizing appearance
Querying with query console; diff viewer; parametrized queries
Database diagramming; CSV editor
Supports version control for Git, SVN, Mercurial, and many others

Here is a video which provides mode insight:

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.

Migrating from SQL Server 2008 to Postgres on EnterpriseDB

With many database vendor products in the market and data intensive applications using them, it is often required to port the application to use the data or, migrate the data so that the application can use it. Migration of data is therefore one of the realities of the IT Industry. Some of the author's previous articles on migration can be found at this link.

Read the full story here .

Data Transfer from MS Access to EnterpriseDB's PostGres

EnterpriseDB sits atop Postgres, the well known open source database server and leverages it to provide enterprise capabilities to Postgres users.

Out of the box EnterpriseDB's Migration Studio supports migration from SQL Server, Postgres and Sybase only. In this article, the Microsoft Integration Services is used to transfer a table form Microsoft Access 2003 to a database  on the EnterpriseDB Postgres server.

MS SQL Server Integration Services 2008 is a great product that handles various ETL Processes very effectively. However, sometimes its error messages can be confusing as you will see in this article. For example, where as the task execution has failed in this example, the data transfer has taken place.

Read on,

Transferring a table in a MS Access 2003 database to PostGres using SQL Server Integration Services 


This is a subscription site and you can login as guest and read free or join as a member using link for SSWUG.ORG on the main page.

If you are new to EnterpriseDB you may also want to read my other article first

Installation and basic features of EnterpriseDB

Enhance your database skills - Jump start on EnterpriseDB

Installation and basic features of EnterpriseDB

Postgres is the well known and most used Open Source OLTP database available today. EnterpriseDB sits atop Postgres and leverages it to provide enterprise capabilities to Postgres users. EnterpriseDB is available for Windows platform as well. It has most of the necessary features of an enterprise class such as advanced development, monitoring, migration and administrative tools with a stable environment. It also has plug-in capabilities for Oracle. In the present form EnterpriseDB claims cost effectiveness versus Oracle and better scalability than MySQL. It can easily integrate with most applications such as Java, Ajax, Ruby, Drupal etc.

Read on...
http://www.packtpub.com/article/installation-and-basic-features-of-enterprisedb

Try out EnterpriseDB and get a taste of Open Source DB

You want to experience the use of an enterprise class of a relational database, try out EnterpriseDB which packages the latest version of PostgreSQL, a popular open source database which has been improved to address all deficiencies compared to the other popular database MySQL. Now what you have is a high reliability scalable database with superior performance that has encouraged many users to move out of Microsoft SQL Server according to some polls conducted. Download EnterpseDB and enjoy.

You have a user friendly management studio that you can use to get all that you need to work with Postgres.