DB Invader is a small windows utility which allows you to explore tables SQL Server Database with ease, you just have to configure it once in XML and all configured servers are available to you for browsing. Firing Select TOP 1000 from SSMS is a tiring task, first you connect to SQL Server, then choose Database, find Table, right click and select “Select Top 1000”. With DB Invader, simply choose Server, Database and Table and it displays all available records in the grid.
It helps you explore all available databases in SQL Server(you can provide multiple DB Servers/Instances simultaneously), tables under them and data contained in tables. You can select any database and browse their tables. Select any table and look into data contained in them.
It helps you explore all available databases in a MS SQL Server, tables under them and data contained in those tables. You can select any database (or add existing database) and browse their tables. Select any table and look into data contained in them. We used DataGridView to explore the data.
Why it was required: Well I was exploring a database and I had to move from one table to another, which required issuing commands again and again although I had an option to issue multiple selects, but it was still not soothing.
So here comes DB Invader (DB Invador). We have used Factory pattern and Singleton pattern in the development so that connection pool is effectively utilized. Explore and let us know your findings, suggestion.
It now supports tables in different schemas as well and you can browse for different SQL Servers or instances simultaneously.
Get it from MSDN : DB Invader
Sample Configuration for DBInvader:
<DB> <name>db1</name> <displayname>My Database 1</displayname> <conn>Data Source=.;Integrated Security=True;</conn> </DB>
Update April 2016, it has been downloaded more than 3,000 times. Feeling Happy and Proud.