Risk free delete, Impact Analysis and Graphical Dependency Viewer for SQL Server. ApexSQL Clean looks for unreferenced and unused database objects like tables and procedures and displays all relationships in a graphical, dependency viewer, using a proprietary dependency viewer that doesn't rely on SQL Server sysdepends table. With ApexSQL Clean you can dynamically browse your object dependencies using visual components like Overview and Heirarchical Dependency Treeview. Print and/or save your target diagram in a variety of graphical formats.
Add instant audit trails to any SQL Database. ApexSQL Audit is an ideal SQL Server auditing solution whether you are relatively new to SQL Server and need an easy to use utility or an advanced user who is comfortable creating your own Audit architecture from scratch. ApexSQL Audit allows you to track inserts, updates, deletes by user, machine, date, application and more integrating the logic directly into your application. The fully customizable and extensible architecture lets you change trigger templates rom directly within the built in IDE, modify architectures (fast reporting, distributed audit log tables etc.) ApexSQL Audit includes a reporting module as well as exports to Excel, CSV.
Increase productivity, reduce errors, standardize your code base and automate repetitive coding tasks with template based code generation. 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 C#, VB.NET, ASP.NET, SQL (and more) in just seconds.
A set of tools for SQL Server comparison, synchronization, and deployment. ApexSQL Comparison Studio offers high-performance and time-saving tools for database and SSIS Package comparison as well as database deployment. ApexSQL Comparison Studio includes ApexSQL Data Diff, ApexSQL Diff, ApexSQL Script, ApexSQL SSIS Compare and ApexSQL Source Control. ApexSQL Comparison Studio also includes 1 year free Support and Upgrades.
Compare and synchronize SQL Database Data. ApexSQL Data Diff compares database backups against each other or against live databases. ApexSQL Data Diff features: automate Database comparisons with a Command Line Interface, compare database backups without having to restore them, synchronize databases in one click, filter objects using regular expressions, visually browse different sections for Compared, Identical and Incomparable objects and more. ApexSQL Data Diff offers you several ways to view the data comparison results and supports SQL Server 2008.
A set of productivity tools for SQL Server administrators including tools for auditing, recovery, reporting, and more. ApexSQL DBA Studio offers tools for common administrator tasks like auditing, compliance, recovery and reporting at a significant discount. ApexSQL DBA Studio currently includes ApexSQL Audit, ApexSQL Data Diff, ApexSQL Diff, ApexSQL Enforce, ApexSQL Log, ApexSQL Recover and ApexSQL Report. ApexSQL DBA Studio also includes 1 year of free support and upgrades.
Debug SQL stored procedures, profile performance. ApexSQL Debug is an Add-in to SQL Server Management Studio that offers step into, step out of, step through debugging with support for conditional break points, watches, call stacks and more. Performance profile stored procedures and functions at the individual line level. Lists the dependent objects called by the profiled procedure. User defined values can be set for procedure parameters prior to profiling. Define conditional breakpoints and display temp table contents.
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.
Compare your SQL Databases Structures in seconds. ApexSQL Diff is a sophisticated database comparison tool that will analyze the differences in SQL Databases Structures. ApexSQL Diff compares live databases, snapshots, scripts, and even Source Control Projects/Labels. ApexSQL Diff now offers SQL Server Support. ApexSQL Diff is 64 bit compatible.
Compare and synchronize databases programmatically. ApexSQL Diff API is a programmable API that allows you to use ApexSQL Diff's and ApexSQL Data Diff's comparison and synchronization engine in your own applications. ApexSQL Diff API offers full programmatic access to our comparison tool engine API, incorporate database compare and sync functionality into your own custom applications, integrate our compare algorithms into your automated build process and other internal systems, includes full working example and complete object model documentation. ApexSQL Diff API can be used with any .NET language.