SQL

SQL Compass gives you the tools you need to to work on your database. You can visualise tables, views, stored procedures and other database objects quickly and easily. It features an offline snapshot of your database schema, so no more need to be connected to a network, meaning the work you are doing isn’t going to be causing any security issues.

Navigation

• Use a familiar tree view to access object details with a single click
• Forward, back and history buttons allow you to quickly switch between recently viewed objects
• Jump to a new object using the superfast Goto menu
• Switch to Checkbox or Marked view modes to limit the tree to only the objects you’re working with
• Save your current position in a handy bookmark
• Share bookmarks with other users

 

Filtering

• Filter all objects by schema, name and SQL
• Build complex filters using regex, case sensitive and whole word options
• Apply selective filtering by object type
• Filter dropdowns remember your recent searches between sessions
• Use advanced filters to search for specific operations on any object such as INSERT, UPDATE and EXEC
• Exclude comments and literal text from filter scope

 

Offline Model

• Share your database schema without compromising data security
• Use lightning fast filtering to quickly find the objects you’re looking for

Comparison

• Compare databases, highlighting different, similar and identical objects
• View line by line comparisons of differing objects
• View column and parameter level differences
• Compare the same database in different environments
• Compare the same database over time
• Apply all filtering functions to database comparisons

 

Projection

• Preview your changes by projecting scripts onto an existing database snapshot
• Use DROP, CREATE and ALTER scripts and even sp_rename to build your projection
• Highlight and filter on objects affected by your scripts
• View the exact SQL actions affecting each object

 

SQLCompass Features Customised Environ

• Customise your experience
• User defined fonts and colours

 

Scripting

• Generate DROP, CREATE and ALTER scripts for any database object
• Generate a range of useful scripts on tables to count all rows in selected tables, discover the maximum length of character columns, backup and restore data
• Generate roll forward and roll back scripts from comparisons
• Build VB and C# object models and CRUD operations quickly and accurately
• Save all scripts to a single file or to multiple files