ApexSQL Developer Studio

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Suite of SQL Developer Tools for comparison/sync, scripting, auditing, Documentation. ApexSQL Developer Studio includes tools for Editing/IDE, to comparison/sync, scripting, auditing, Documentation, Dependency Analysis, Code Generation and more.  These tools all provide specific features that SQL Developers use on a frequent basis,  from daily code writing and daily tasks to versioning scripts and objects, comparison, scripting, code generation, reference analysis and auditing tasks.  All of the tools are included in a single download and installation. All tools in ApexSQL Developer Studio are licensed per Developer making it easy to procure a license of ApexSQL Developer Studio for each member of your SQL Developer team.

Our regular prices are shown below. Please logon to see your discounted prices.

ApexSQL Developer Studio without Support

ApexSQL Developer Studio with 1 yr Support & Upgrades

ApexSQL Developer Studio with 2 yr Support & Upgrades

ApexSQL Developer Studio with 3 yr Support & Upgrades

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase.  All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed above including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

The tools in ApexSQL Developer Studio include :

• ApexSQL Audit - Active data auditing for SQL Server. Includes multiple modules for reporting, data management, trigger management and more
• ApexSQL Clean - Search and Destroy for unreferenced SQL Objects in both the database and client code. Includes visual dependency viewer.
• ApexSQL Code - A code generation tool, perfectly streamlined for SQL Server Database developers
• ApexSQL Diff - Compare and Synchronize Databases. Includes Command Line Interface
• ApexSQL Doc - Database documentation (.chm and .html)
• ApexSQL Edit - An Editor/IDE for SQL Server. Includes snippets, object browser, intelliprompt and more.
• ApexSQL Script - Convert Database Structures and Data into scripts, exe's, packages etc. for versioning, deployment and more

More information about each tool can be found below and on the individual product pages on this site.

ApexSQL Audit

Add instant audit trails to any SQL Database

• Track Inserts, Updates, Deletes by user, machine, date, application and more integrating the logic directly into your application
• Fully customizable and extensible architecture. Change trigger templates rom directly within the built in IDE, modify architectures (fast reporting, distributed audit log tables, etc
• Reporting module as well as exports to Excel, CSV.
• Per Client licensing - audit unlimited servers.

Whether you are relatively new to SQL Server and just need an easy to use utility or you are an advanced user who is comfortable creating your own Audit architecture from scratch - ApexSQL Audit is a great SQL Server auditing solution.

ApexSQL Clean

Risk free delete, Impact Analysis and Graphical Dependency Viewer for SQL Server

• Ever wonder how many objects in your database were really referenced/used by other database objects or client applications?
• Want to view database dependencies visually even across databases and servers and/or export to xml/html for additional analysis
• Are you interested in column level dependencies for pre-impact analysis?
• Concerned about the unreliability of native sql server dependency tracking (i.e. sysdepends table still unfixed in SQL 2005)?

ApexSQL Clean looks for unreferenced and unused database objects like tables and procedures and displays all relationship in a graphical, dependency viewer, using a proprietary dependency viewer that doesn't rely on SQL Server sysdepends table. Dynamically browse your object dependencies using visual components like Overview and Hierarchical Dependency Treeview. Print and/or save your target diagram in a variety of graphical formats.

ApexSQL Code

Increase productivity - Reduce Errors - Standardize your Code Base - Automate repetitive coding tasks with Template Based Code Generation

• Do you spend a lot of time manually writing Data Access Layer code, stored procedures or even forms for CrUD (Create, Update Delete)?
• Have you ever "fat fingered" names of parameters, datatypes or made other common errors in blocks of rote, repetitive code leading to annoying errors?
• Would you rather spend time designing software than typing code?
• Would you like to ensure you code base is more standardized with each class and function written the exact same way?

ApexSQL Code is a Rapid Application Development (RAD) Code Generation tool, streamlined specifically for Microsoft SQL Server, that enables you to automatically generate thousands of lines of perfect C#, VB.NET, ASP.NET, SQL (and more) in just seconds solving these problems and making good coders even better.

ApexSQL Diff

Compare your SQL Databases in seconds - including both Data and Structure.

• Automate Database comparisons with a Command Line Interface
• Synchronize your database
• Integrate seamlessly into your build process

ApexSQL Diff is a sophisticated database comparison tool that will analyze the differences in tables, procedures, views, users etc. between two SQL Server databases.

ApexSQL Diff implements a state of the Art solution to the complex database comparison scenarios including many unique features like Diff codes, RegEx object filters, Project Wizards and much more.

ApexSQL Doc

Comprehensive and richly detailed Database documentation

• Document multiple databases at once but still be able to include or exclude individual objects
• Extensive Command Line Interface
• Include Dependency diagrams in your documentation
• Custom tags, embedded customizable, text blocks and literally scores of customizable options
• Support for both HTML and CHM output
• VS2005 style, Collapsible regions and HTML 2.0 (hxs) support

ApexSQL Doc is a tool to document your SQL Server Database into Compiled Help or HTML documentation. ApexSQL Doc offers extensive, comprehensive and thoroughly detailed SQL Database Documentation products.

ApexSQL Edit

Improve your productivity with an SQL IDE designed by SQL Developers!

ApexSQL Edit is an 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.

Scripts can now be run in "Test mode" which will automatically roll back scripts immediately after execution.

ApexSQL Script

Process SQL Server Data and Objects into T-SQL Scripts, Executables and Deployment Packages

• Apex SQL Script is a SQL tool that converts Databases into scripts, .net EXE's, deployment packages or into source control
• Scripts are ordered based on proprietary dependency algorithms to ensure proper order of generated scripts
• Scripts can be created from Databases or Source control labels (all SCC compliant source control systems are supported)
• Includes Command Line Interface

ApexSQL Script allows a rich array of value added scripting attributes to embed customizable text, tags, dates, comments etc into your scripts to transform your output into a richly tailored output, that comes in a variety of formats.

Support

What support options are available?
ApexSQL take support seriously they offer support via their Support Forums as well as Phone Support for customers who have purchased a Maintenance Contract for Support and Upgrades.