Apex SQL Edit 2008.04

Apex SQL Edit 2008.04 is a new, powerful and extremely easy to use integrated SQL database editing tool/IDE which provides source control integration with Visual Source Safe, Vault, Microsoft Team System and a variety of other SCC-compliant source control systems.

ApexSQL Edit provides powerful features like intelliprompt, customizable snippets, object explorer, sql formatting, data editing, build queries visually and many other features. Whether you are a single developer or on a large team fully integrated with source control, ApexSQL Edit provides powerful features and significant productivity advantages. With ApexSQL Edit, you can-- - Integrate your SQL development environment with Source Control - Write SQL more quickly and efficiently (intelliprompt, dynamic code snippets, code templates are just some of the Rapid Application Development features) - Organize your work into sophisticated project groups that combine scripts, query results, schema items, notes and tasks into a logical work unit - Personalize your development environment to suit exactly how you work.

Major Features: 

1. Integrate with Source Control - ApexSQL Edit supports any SCC-compliant source code control system like Visual Source Safe, Team Foundation Server, Subversion, SourceGear Vault, Perforce and more.
2. Browse Database schemas - ApexSQL Edit's Schema Explorer allows users to browse servers, databases, individual objects and their properties launching powerful contextual menues and source control options.
3. Manage objects visually, perform batch operations on multiple objects - One of the most powerful features of ApexSQL Edit is the Object Explorer which allows you to group, sort and manage objects in a powerful tabular format. Batch operations like check in, check out, get latest empower users to work more seamlessly with source control. Additional columns allow browsing object meta data, dependencies, scripts and more.
4. Interrogate Database Schema collections and Scripting options visually - ApexSQL Edit's Intelliprompt allows you to focus on writing SQL statements for your database objects without focusing on the details of exact column, table and variable names. Not only can Intelliprompt significantly speed up your SQL writing time, but annoying typos and mistakes are also significantly reduced.
5. Enjoy more readable code - Collapsible regions in code on command eliminators like BEGIN and END to provide a Visual Studio like presentation of your SQL Code.
6. Get Hints and Descriptions of objects embedded in your code - When writing code, the tooltip feature displays object descriptions or syntax hints.
7. Edit Data - ApexSQL Edit allows users to view and edit data. Filter, sort, group, edit all in a single powerful interface.
8. Build queries visually - ApexSQL Edit includes a powerful visual query editor that allows you to build complex queries.
9. Avoid spelling mistakes and syntax errors with Auto-Replacements - With ApexSQL Edit’s auto-replacement feature you can set it to ensure commonly misspelled words are corrected automatically.
10. Improve productivity with Code snippets - Code Snippets allow the user to predefine blocks of SQL/Code with the ability to define replacements throughout the snippet where users can customize the final inserted text. Snippets offer a variety of options including automatically setting cursor location in completed replacement text.
11. Object search - The Object Search feature searches for text matches in SQL objects names. Object Search allows you to search for any objects within a specific database with support for wildcards and loose matching.
12. Text search - The Text Search feature searches for data text matches in tables and views. By checking boxes besides table and view names you are able to filter in only specific objects. Also you are able to choose additional filter options like search text type columns, search date columns, search Unique Identifier columns, search Views, to use partial matching.
13. Integrate large SQL developments teams onto the same source control server - ApexSQL Edit allows multiple SQL Developers to share mappings and otherwise work seamlessly in the same integrated source control environment, with ApexSQL Edit's powerful centralized mapping feature.
14. Fully customize menus and behaviors - ApexSQL Edit allows full granular customization of menu actions (i.e. Double click) on an object specific basis. For example, double clicking a Table might open it for editing but double clicking a Procure might script it to the editor. Entirely new menus can be custom designed and added to the existing context menu for that object.

Enhancements: Updated product

Requirements:

1. MDAC 2.8(ADO 2.8) MSSQL Server v7, 2000, 2005, or 2008
2. .NET2.0 SP1 Run time