What does DbOctopus offer that is not available from Management studio?

Intelligent SQL Editor

  • Intelligent code completion
  • Auto creation of JOINs - you just select relation from a list
  • Quick creation of standard scripts for any table, view or stored procedure
  • Tooltips for stored procedure and function parameters

Database Relations

DbOctopus examines all foreign key relationships from your database and uses them to help you easily work with connected tables:

  • Navigate to related rows in parent or child tables
  • Show additional columns from referenced tables - join in a click
  • Look up data in related foreign tables
  • Display child rows from dependent table as you browse main table

Easier handling of large tables

  • Instant filtering, sorting and grouping of loaded data
  • Paging
  • Find and Replace in database tables and views like in text editor

Examine database structure and dependencies

  • Explore table, view and sp dependencies: referenced, foreign key, depend on.

Easier Stored procedures

  • Execute stored procedure and Sort, Filter, Group and Print result data
  • Parameters could be stored so that you don't have to enter them every time you execute SP.
  • Search through stored procedure result

Pivot Tables

  • Transform table, view and sp data to pivot table (Excel like)

Enhanced Copy Paste

  • Copy and Paste multiple rows between tables
  • If pasting multiple rows fails because of table constraints, you can easily fix problematic cells before commiting
  • Copy and Paste data between Excel sheet and database tables directly

Export and Import Data

  • Export table data to xml, html, Excel, pdf and text format
  • Import and bind data from xml to database table directly
  • Print

 

Take a feature tour >>