Jorge's Quest For Knowledge!

All about Windows Server, ADDS, ADFS & FIM (It Is Just Like An Addiction, The More You Have, The More You Want To Have!)

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

Posted by Jorge on 2011-09-06


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.

image

 

  • 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

image

 

  • 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

image

 

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

image

 

  • Easy-to-use search mechanism

נורת חשמל you do not need to use SQL query

image

 

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

image

 

image

 

  • You can preview and print your tables

image

 

  • Import/Export data from/to Excel

image

 

  • SQL Builder supporting a wide range of databases types

image

 

  • Alternatively, You can write your own SQL statement

image

 

  • Execution Log

image

 

image

 

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

-

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

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: