SQL Server IDE

Atlantis SQL Everywhere is a free SQL Server IDE (Integrated Development Environment) which supports all
versions of Microsoft SQL Server from 2000 to 2008 and comes with the most fully-featured and accurate
SQL Intellisense® engine available – use it to turbocharge your productivity.

If you use Management Studio or Enterprise Manager as your SQL editor, then you’re going to be
amazed at what our SQL Server IDE SQL Everywhere can offer you over and above what you’re used to. The highly optimised
Intellisense® engine provides you with in-place suggestions wherever you place your caret. Inside a
stored procedure? No problem! Nested 10 levels down in an iterative cursor algorithm? No problem!
Joining multiple SQL tables each with their own aliases? No problem! SQL Everywhere knows exactly what
can be typed at any point and will let fill you in on this information unobtrusively, just when you
need it most.

Auto completion shortcuts work to let you type more by typing less: common statements are abbreviated
to a few key strokes. Pressing tab after importing an identifier such as a table name intelligently
creates a unique, short alias for you. Code snippets easily import common boiler-plate code fragments
and highlight the areas to be edited.

Extensive syntax highlighting neatly colours what you type by class and function. Unique
“Declaration Tracing” will identify the declaration position of identifiers and symbols that you’re
referencing by hovering your mouse cursor over them.

But it’s not just about the ground-breaking code editor, SQL Everywhere is a SQL Server IDE that offers so much more...

The built-in data SQL export feature is an extremely handy way to automatically script SQL statements
which can be kept for backup purposes or run against other databases to import data. The SQL Export
is intelligent enough to manage the order of the exported statements so that upon import, referential
integrity constraints do not produce errors.

“Auditing” stores the results, messages, errors & SQL from every execution. A powerful search feature
lets you make sense of all this historic data, and allows you to find executions against a specific server,
database or date range. Choose whether to search SQL, results and/or messages.

Execute a SQL statement on many databases at once using our SQL multiple server technology -
“Multiple Execution” - a unique feature among SQL Server IDE products. Run on entire groups / servers, or select which databases to execute against. View
results, messages and errors from each individual database, or view them all at once. These enterprise-level
features have been thoroughly validated in the field against production-scale databases running under live
environments and have proved time and time again to be invaluable.

SQL Everywhere massively speeds up database development and administration. The savings in development
time make a significant contribution to ensuring that your project will deliver on time solutions and
that they’ll be spot on, first time.

Features include:

This provides object name & keyword suggestion where relevant, and also allows
users to define shortcuts (e.g. ‘ssf’ -> ‘SELECT * FROM ’)

This also allows developers to use Visual Studio-style code snippets to reduce
repetitive typing tasks

Support for find & replace using regular expressions allows developers to make the
most of their scripting abilities, and transform complicated queries easily

Database registration & grouping

This allows developers and DBAs to group multiple databases into groups, irrespective
of what server they reside on. This allows developers to work on groups of databases by purpose,
rather than servers.

Setting a default context allows you to get to work straight away in the database project you're working on.

Connectivity checking & alerting gives the user instant visual feedback on what databases
are available, and whether new databases have been created on existing servers.

Data editing

This allows developers to edit data using a familiar data grid without the overhead
of loading the normal SQL Server management tools.

Integrated object scripting and data scripting

This allows developers to script objects by right-clicking on the object name directly
in the editor, rather than having to find it through an object list.
The same convenience is given for scripting of INSERT statements for data.

Code library

This allows developers to build up a library of T-SQL code which they use for common tasks,
and allows them to insert that SQL into the current editor window through the context menu

Process viewer

This allows DBAs to see the processes running on the currently connected server with the
ability to categorise them in multiple ways.

Advanced features:

Multiple execution

This allows developers to run SQL on several databases in one hit, allowing them to perform
schema updates on multiple targets, or to run the same query from multiple data sources.

Auditing

This allows an audit trail of executed SQL and returned results to be created, allowing
greater understanding of execution activity over time, and also reducing the risk of lost work
through unsaved or deleted files.

Code generation

This allows developers to generate a .NET class to store any result set automatically, as
well as being able to generate INSERT/UPDATE/DELETE stored procedures for any table automatically.