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 >>