(2011-09-06) Database Browsing/Editing Tool

Have you ever had the need to quickly browse and/or edit a database on some database server without installing SQL Management Studio (for SQL Server) or some other huge database management tool, incl. the ones for other database formats? Well, look no further! I found this very interesting Database browsing/editing tool that assisted me in working with the attribute store that I had configured for my ADFSv2 test environment. You cannot compare it with SQL Management Studio for example, with it supports a huge interesting features which work me. I used this a lot in my test environment when I need to browse/edit a database from a server not hosting SQL Server.

–

ORIGINAL SOURCE FOR THE TEXT/PICTURES BELOW: http://blogs.microsoft.co.il/blogs/doli/archive/2011/07/20/free-tool-database-browser.aspx

–

Database Browser is an easy to use, free portable tool, which can connect to a variety of database types and browse or modify data, run SQL scripts, export and print data.

 

• This tool is free and portable
• The browser supports variety of direct databases connections :
  • Oracle
  • Microsoft Sql Server
  • ODBC
  • MySql
  • OleDB
  • PostgreSQL
  • SQLite
  • Microsoft Sql Server Compact
  • Interbase
  • Firebird

 

• Supported OS :
  • Windows 2000
  • Windows XP
  • Windows Vista
  • Windows 7

• Easy Table browsing – just click on the table name and the content will be shown on the right pane

 

• Supports Unlimited number of connections
• Switch between connections by clicking the desired connection

 

• Easy-to-use search mechanism

you do not need to use SQL query

 

• You can edit your table as if it was an excel sheet
  • change column order
  • sort column
  • use filters
  • …

 

 

• You can preview and print your tables

 

• Import/Export data from/to Excel

 

• SQL Builder supporting a wide range of databases types

 

• Alternatively, You can write your own SQL statement

 

• Execution Log

 

 

• The browser has a very important button – read only mode button

–

Cheers,
Jorge
———————————————————————————————
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always evaluate/test yourself before using/implementing this!
* DISCLAIMER: https://jorgequestforknowledge.wordpress.com/disclaimer/
———————————————————————————————
############### Jorge’s Quest For Knowledge #############
######### http://JorgeQuestForKnowledge.wordpress.com/ ########
———————————————————————————————