SQL Database Comparison & projection

SQL Database comparison and projection.

SQLCompass allows you to visualise tables, views, stored procedures and other database objects, through an offline snapshot of your database schema, quickly and easily.

Rapidly drill down to the SQL your looking for using flexible, rich search options without the need for a network connection.

SQL Database Tools

Unfamiliar SQL Database?

Started a new job and struggling to get to grips with existing technology? SQLCompass gives you a great head start when working with an unfamiliar database.

Working in a team?

Are you working in a collaborative environment where you need to quickly find relevant objects in the database which have been authored by other members of the team? SQLCompass can do that.

Need to compare? 

Suffering schema drift? SQLCompass will highlight differences in your database schemas in multiple environments, or over time.

SQLCompass versions - what is the difference?

Trial Version

Full Version

Build offline database snapshot from connection
Build offline database snapshot from connection
Build offline database snapshot from connection
Build offline database snapshot from scripts
Build offline database snapshot from scripts
Build offline database snapshot from scripts
Filter by Schema
Filter by Schema
Filter by Schema
Filter by Name
Filter by Name
Filter by Name
Filter by SQL Text
Filter by SQL Text
Filter by SQL Text
Exact, Fuzzy and Regex filtering
Exact, Fuzzy and Regex filtering
Exact, Fuzzy and Regex filtering
Filter by INSERT, UPDATE, EXEC ...
Filter by INSERT, UPDATE, EXEC ...
Filter by INSERT, UPDATE, EXEC ...
Build multiple SQL scripts
Build multiple SQL scripts
Build multiple SQL scripts
Build single SQL script
Build single SQL script
Build single SQL script
User Comment Parsing
User Comment Parsing
User Comment Parsing
Database Comparison
Database Comparison
Database Comparison
Database Projection
Database Projection
Database Projection
Multiple Documents
Multiple Documents
Multiple Documents
Irritating re-activation every 4 hours
Irritating re-activation every 4 hours
Irritating re-activation every 4 hours
Customisable Colours and Fonts
Customisable Colours and Fonts
Customisable Colours and Fonts
History and Quick Navigation
History and Quick Navigation
History and Quick Navigation
SQLCompass
Pointing you in the right direction

Database Comparison and projection in a snapshot:

Working in a collaborative environment?

Easily find relevant objects authored by other team members

Using a legacy database?

Quickly refresh your understanding of how your MSSQL all fits together

Require advanced filtering options?

Filter by schema, name and SQL definition using rich options including case sensitive, fuzzy and regex.

Require advanced search/filtering options?

Share search results or use as script generation and filter by INSERT, UPDATE and DELETE

Secure offline model

The offline model allows a developer to see the entire structure of a database schema without requiring access to the database itself. This facilitates an accurate and efficient development processes without compromising data security

How can I check my changes?

Use the projection option

Using filtering and comparison options, you can build a set of scripts to roll out your changes, but did you miss something?

Generate an image from the production database and then project your scripts onto this image.

You can then compare the result with your development version (we know a tool that does that) and instantly spot any anomalies.

Of course any errors in your scripts will also be highlighted (but if you used SQL Compass to generate the scripts then there won’t be any)

Offline snapshot of your database schema
It’s simple – we want developers to have have more choice in how they work in SQL environments without the hefty price tag  that many of the options out there charge. Start using our tools and we know you’ll get your project completed quicker, at less cost and develop a greater understanding of the databases you work with.