Improve your productivity with a powerful SQL IDE designed by SQL Developers!

ApexSQL Edit is a powerful IDE especially designed for advanced SQL Server developers including integration with source control, Intelliprompt, sql formatting, data editing and advanced features not found in other SQL IDEs like procedure/column Intelliprompt, Collapsing Regions, Snippet Editors and more.

ApexSQL Edit has been modified to provide many new features, including support for Microsoft SQL Server 2005, centralized mapping, Object Explorer, code snippets, object notes, context sensitive options while editing such as What Is... 

Product Information ApexSQL Edit News ApexSQL Edit Datasheet What's New? SQLMag Product Review

ApexSQL Edit Help File Training Videos ApexSQL Edit Knowledge Base

Screen Shots
 

Features

• Centralized Object Mapping repository. This feature allows groups to share object mappings in source code and automatically update mappings across group members
• Advanced copy provides sophisticated copying of query results and other grid output to HTML and a variety of customizable formats
• Object Explorer provides quick reference to object meta data (DDL, references, permissions, etc.) as well as allowing drill down to sub-level objects. This powerful new panel can be used in lieu of the tree view object browser or in tandem
• Code snippets--customizable xml based code snippets can be used to significantly improve coder productivity when adding boiler plate code. ApexSQL Edit snippets are dynamic (hot spots, built-in intellilist, etc.) and totally customizable (shortcuts, tooltips, enter key behavior)
• Scripts can now be run in "Test mode" which will automatically roll back scripts immediately after execution
• Script outlining with collapsible regions just like Visual Studio .NET
• Drag/drop of files into the editor
• Deployment Projects - use ApexSQL Edit to manage your deployment process from Visual Source Safe
• Disconnected Query Windows
• Source Control Mapping
• Hot keys for cycling through result windows
• Ability to backup a database from the editor
• Statement Logging to allow all statements executed by the editor to be logged in a database with relevant information
• Exporting to HTML
• Table, Procedure, Column and Column Value Intelliprompt
• XML Queries
• Drill down and around
• Quick Info allows the user to get more information about particular values from a result set without having to execute a separate query
• Custom SQL Formatting
• ApexSQL Edit provides several different means to save and print results. ApexSQL Edit will save results as XML, CSV, and HTML
• Visual interface for Table Join navigation
• Quick Query - allows you to simply select a table and then enter values for any number of columns in the table and retrieve the results very quickly
• Auto-Replacement - You can define your own custom replacement tokens
• Custom Context Menus - means for the user to add their own context menus to Tables, Columns, Stored Procedures, and soon to Databases to execute custom actions
• Multiple Connection Execute - execute a SQL statement against multiple connections simultaneously with resultsets from all sources returning to the results set window.
• View images stored in the database in image fields directly from the editor
• SQL Server Reporting Services Integration - Report Explorer, Create Report, View Report Queries and View Reports
• With Custom Commands users have the ability to define their own commands that can be executed within the query window
• Provide context sensitive information about database objects in the system catalogs
• Integrate with SCC to to check in/out directly from the editor
• Object Notes provides the developer with the ability to create short notes attached to objects in the database such as tables, views, procedures, functions, and triggers
• Resultset Filtering and Grouping - allows resultsets returned to the editor to be grouped and filtered directly in the result grid
• Edit data within a table directly in the editor

Reviews

This IDE for SQL Server developers has added an amazing number of features since I last looked at it (when it was still named msSQLed). Better yet, new releases are coming out on a frequent basis with more innovative features. If your work includes daily mucking about with SQL Server databases, you'll want to give this one a try.

For starters, you get a SQL authoring environment that includes Intelliprompt, outlining, source code control..., templates, snippet expansion, color coding, and more. There's also a rules-based formatting engine to keep your SQL looking pretty. After writing the SQL, of course you can execute it to either a grid or text. The grid is quite spiffy; it supports drag and drop methods for grouping and ordering, among other things.

The fun is just starting when you get your results in the grid. You can save them as XML, HTML, or CSV. You can tear off the results into a dockable window for later reference. Or if you'd rather, you can generate a "client viewer" application, which packages the result set into a little .NET executable that you can send to others to explore, along with filtering and sorting capabilities.

Speaking of .NET, how about NUnit integration? It's here. Assuming you've got NUnit installed, you can create, manage, and run unit tests for your stored procedures from the ApexSQL Edit interface. If you're working with unit tests to build up complex batches, you'll also appreciate the ability to run everything in test mode - it automatically rolls back any changes.

There are plenty of other features here as well. You get integration with SQL Server Reporting Services, so you can use ApexSQL Edit to design your report and then quickly publish it. You get XML query output using a sensible stylesheet rather than endless long lines. You get image display in the query grid or in separate windows. I'm sure there are other features that I'm missing this morning as well.

...There's a trial version available for download if you want to see for yourself.

Mike Gunderloy
DevCentral Newsletter Oct 2004

"What you'll find here is an editor with a modern IDE with color-coding and Intelliprompt. Or at least, that's what you'll find here for starters. Here are a few of the other features to like in ApexSQL Edit:

• Instant integration with SQL Server Reporting Services and Visual SourceSafe (though not yet with other source code control systems)
• FOR XML result sets displayed using IE's XML stylesheet rather than plain text
• Configurable drill down and quick info options that let you go from values in a result set to other information elsewhere in the database
• Stored queries that can have their own runtime parameters
• Object notes that help you keep a running development log
• The ability to show images from binary fields (and how many times have you wished for THAT?)
• Customizable "pretty-print" SQL formatting
• Customizable expansions to save you typing time
• Exporting and formatting in a variety of formats "

Mike Gunderloy
Mastering SQLServer 2000

What People are Saying