Apex SQL Edit description
This software is an integrated SQL database editing tool/IDE

This is a complete development, editing and deployment environment for SQL Server Developers.

Apex SQL Edit offers many new features including object notes, context sensitive options while editing such a What is…and Open of stored procedures as well as results pane that allows grouping and filtering including the ability to provide automotive filtering with drop down selections.

Apex SQL Edit provides Visual Source Safe Integration, Intellisense and powerful features not found on other SQL Editors.

Here are some key features of "Apex SQL Edit":

· 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
· Stored Procedure Unit Testing. ApexSQL Edit will allow you to easily create test plans for your stored procedures and execute a set of tests with the click of a button, getting back pass/fail results with the error messages you provide
· 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 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


Requirements:

· MDAC 2.8(ADO 2.8)
· MSSQL Server v7, 2000 or 2005
· .NET 2.0 Run time


Limitations:

· 30 days trial