Apex SQL tools Software

Apex SQL Diff

Apex SQL Diff is Microsoft SQL Server based high speed database comparison tool that will analyze the differences in tables, procedures, views, users, etc. between 2 databases. You will be able to visually observe the differences in the object''s script and programmatically synchronize the databases based on the comparison analysis. It is perfect for scheduling and running unattended (overnight) jobs from command line. It also includes powerful HTML reports, XML, and CSV exports. It has Office2003 user interface including grid grouping, theme support and outlook bar.

Keywords: database comparison database synchronization data comparison data synchronization sql compare sql diff database compare data diff schema syncing separators

Apex SQL Log

Apex SQL Log is a powerful SQL database auditing and recovery tool that analyzes SQL Server''s own Transaction Log to display information on data and structural changes. Since Apex SQL Log reads the Transaction Log, no database overhead is required and audits can be done on changes made even before the SQL log tool was installed. Apex SQL Log shows computer, user (including NT User), and the application that made the change and shows a full history of the audited record. Apex SQL Log includes powerful recovery functionality that can recover lost, deleted and truncated data and data from dropped tables. Features - live log support - XML export tool - Passively audit using transaction log backups or live log files what has been inserted, updated (both before and after), and deleted from every table in your database, Powerful filtering, grouping and sorting of log data, View field level data for each row in insert, update and delete. - View history of changes of a row. - Audit seamlessly multiple transaction log backups or live log files. - Currently Apex SQL Log reads database back-up files and processes them into readable information. You can apply sophisticated filters, grouping and sorting to the data

Keywords: sql recovery data recovery database recovery sql audit sql auditing sql server audit log ms sql server sql tool microsoft sql database transaction log ms sql pitches

Apex SQL Clean

Apex SQL Clean tool looks for and deletes unreferenced and unused Database objects like tables, views and procedures from within the database itself (cross-dependencies) and also from client applications (like a VS.NET project). References are created using proprietary technology that doesn''t rely on SQL system tables. Apex SQL Clean includes a powerful visual Dependency viewer that converts database dependies into a graphical display. Apex SQL Clean will analyze a client whether it be VB, ASP, Delphi etc to determine what SQL objects are actually being used and what objects aren''t. It will also analyze the database itself to see what internal references exist among SQL objects. Based on the Apex SQL Clean analysis it will generate a file of SQL drop statements to Clean your database of these useless objects. Features - Support for tables, views, procedures, rules, defaults, triggers, user defined datatypes, user defined functions and file dependencies - Interface shows Object dependencies and objects with dependencies to it. - Graphical display of number of unreferenced objects. - DDL script for object colorizes referenced object names to allow you to visual spot the dependencies. - Users have the ability to create file search pattern to analyze all files of a particular language or project (i.e .cs, .vb, .frm, .aspx, .pas, .cls) - The file processing engine is recursive - simply point to a directory and it will search all subdirectories for files that match the search pattern you create. - Automatic drop statement creation. Interface shows whether file is referenced, has references and the number of each. Simply clicking on the object will display all references. - Double clicking on any object will script it. - Interface supports grouping/ungrouping by object type.

Keywords: sql tools sql tool unreferenced objects unused objects dependencies visual diagram dependency viewer risk free delete address book entries

ApexSQL Clean

ApexSQL Clean looks for and deletes unreferenced and unused Database objects like tables, views and procedures. If database object bloat is the problem, ApexSQL ApexSQL Clean is the solution. Your database may have many stored procedures, tables and views that aren't being used anymore but unless you determine which of your objects fall into this category you will be stuck with them forever. ApexSQL Clean will analyze a client whether it be VB, ASP, Delphi etc to determine what sql objects are actually being used and what objects aren't. It will also analyze the database itself to see what internal references exist among SQL objects. Based on this analysis it will generate a file of SQL drop statements to Clean your database of these useless objects. Features - Support for tables, views, procedures, rules, defaults, triggers, user defined datatypes, user defined functions and file dependencies - Interface shows Object dependencies and objects with dependencies to it. - Graphical display of number of unreferenced objects. - DDL script for object colorizes referenced object names to allow you to visual spot the dependencies. - Users have the ability to create file search pattern to analyze all files of a particular language or project (i.e .frm, .asp, .pas, .cls) - The file processing engine is recursive - simply point to a directory and it will search all subdirectories for files that match the search pattern you create. - Automatic drop statement creation. Interface shows whether file is referenced, has references and the number of each. Simply clicking on the object will display all references. - Double clicking on any object will script it. - Interface supports grouping/ungrouping by object type.

Keywords: sql sql clean database ms sql server sql tool tables views procedures apexsql clean apexsql clean looks deletes unreferenced unused database objects oscillate

ApexSQL Audit

ApexSQL Audit proves a comprehensive, enterprise level active data auditing tool for Microsoft® SQL Server© 7 or 2000 Database auditing unmatched on the market today. This ApexSQL Auditing tool is both configurable and scriptable and ships with the power of Microsoft VBScript parser. 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 and modifying trigger templates - ApexSQL Audit is the perfect SQL Server© active auditing solution solution for you. [New] ASP web reporting front end with full source code for standard and aggregate audit reports. [New] Database transaction UNDO - this powerful new feature allows for the reversal of database operations including inserts, updates and deletes. This powerful module is incredibly robust - it will produce a pre-undo report to explain the impact of changes and a post-undo report indicating any problems. This process even allows for a complete rollback of all undo operations pending the results of the post-undo report. Features FREE web based (ASP and ASP.NET) reporting client WITH FULL SOURCE CODE. The source code is available to registered customers via Customer Center. Scriptable, customizable trigger templates that allow you to modify triggers - no more hard coded, take it or leave it audit architectures. Profiles automatically save your field and audit selections from your last session. No more tedious reconstruction of Audit plan. Trigger management module - delete, enable / disable view triggers in an easy to use interface. Incredibly functional template editor enables you to modify triggers or create your own using Microsoft VBScript or JScript and leveraging the full power of Microsoft Script parser and debugger. Template editor offers intellisense support for the Audit object model and includes a built in property page. and more...

Keywords: audit database code creation sql data scripts triggers sql tools ms sql sql server undo apexsql windows lockwoodtech auto-audit apexsql audit audit

ApexSQL Code

ApexSQL Code is a Rapid Application Development (RAD) Code Generation tool for Microsoft® SQL Server© 7 or 2000 that enables you to automatically generate thousands of lines of perfect ASP, VB, C#, SQL (and more) code in just seconds The key feature of ApexSQL Code is Template based code generation that allow users to configure custom code patterns automated with the scripting language of your choice, VBScript or JScript. Features [NEW] A cool template wizard that makes creating templates as easy as following 7 simple steps. [NEW] A powerful template property page for editing templates in place with simple picklists and dialogs. [NEW] XML based templates - allows for template attributes to be embedded directly in the template structure itself. [NEW] Built in Session and Application variables. [NEW] Programmatic control of file operations and dialogs directly from the template. Files can be output, appended or all file operations can be suppressed if user chooses to use File System Object. [NEW] ApexSQL Code now automatically remembers all of your table, view, sproc, field, parameter and result column selection in between sessions and for a specific database. These selection profiles can be saved, cleared and retrieved. Choice of VBScript of JScript for template scripting - handles looping including For Each loops, constructs, error handling, etc. Your ability to create code patterns is virtually unlimited. Extensive template library including C#, VB.NET, AsP, VB, SQL and Delphi templates Support for unlimited Include files just like ASP! Real Intellisense to navigate ApexSQL Code object Model Default color coded text editor to manage templates currently supports ASP / VBScript, VB, Java / JScript, CSharp and SQL. Multiple tables, views and stored procedures can be scripted at once and even in the same template. more...

Keywords: rad code generation tool asp delphi vb net c templates apexsql code rapid application development rad code generation tool time transfer

ApexSQL Log

ApexSQL Log is a powerful SQL database auditing tool that analyzes SQL Server's own Transaction Log to display information on data and soon ... structural changes. Since ApexSQL Log reads the Transaction Log, no database overhead is required and audits can be done on changes made even before the tool was installed. Features - NEW - live log support. - NEW - XML export. - Passively audit using transaction log backups or live log files what has been inserted, updated (both before and after), and deleted from every table in your database. - Powerful filtering, grouping and sorting of log data. - View field level data for each row in insert, update and delete. - View history of changes of a row. - Audit seamlessly multiple transaction log backups or live log files. - Currently ApexSQL Log reads database back-up files and processes them into readable information. You can apply sophisticated filters, grouping and sorting to the data

Keywords: sql audit log ms sql server sql tool microsoft sql database transaction log apexsql log powerful sql database auditing tool financial projections

Page 1 out of 2    1 2