The value of ApexSQL Universal Studio is in the large 80% discount, free new tools for next 12 months, strong product forecast and simple and inexpensive annual subscription model.
The tools in ApexSQL Universal Studio include:
• ApexSQL Audit - Audit SQL Server Databases
• ApexSQL Clean - Risk free deletion and Impact analysis
• ApexSQL Code - Generates code from customizable templates
• ApexSQL Data Diff - Compare and synchronize SQL Database Data
• ApexSQL Diff - Compare and synchronize SQL Database Structures
• ApexSQL Doc - Document SQL Databases and SSIS packages
• ApexSQL Edit - A complete Editor / IDE for SQL Server
• ApexSQL Enforce - Implement industry best practices and database standards
• ApexSQL Log - Audits data changes, rollback and reconstruct transactions
• ApexSQL Recover - Recover deleted, dropped, corrupted, or lost data
• ApexSQL Script - Script and package SQL objects and data
• ApexSQL SSIS Compare - Compare SQL Server Integration Services (SSIS) packages
• ApexSQL Diff API - Compare and synchronize databases programmatically
• ApexSQL Log API - Audit SQL databases programmatically
• ApexSQL Debug - Debugs SQL stored procedures, profiles performance
• ApexSQL Refactor - Format SQL Code
• ApexSQL Source Control - Expand the source control capability of ApexSQL products
ApexSQL Universal Studio is like a MSDN subscription just for SQL Server Tools including:
• Productivity multipliers (Code Complete, Refactors, Code Formatter)
• Team integration (via Source Control integration)
• Change management (for database schema & data, SSIS packages)
• Database Auditing (auditing and reporting, transaction log reading, full historical row history)
• Disaster Recovery (recover from inadvertent data loss from drops, deletes, truncates, corrupt databases and more)
ApexSQL Universal Studio 2008 will:
• Passively audit with no overhead by reading the SQL Server Transaction log
• Insure your databases against almost every possible inadvertent data loss scenario.
• Improve productivity with code complete, code snippets, and automatic error syntax highlighting.
• Standardize code structure with SQL Formatting.
• Transform code with a variety of powerful Refactors.
• Manage changes and synchronize databases, propagate changes to production, rollback versions, and undo changes.
• Recover row-level data directly from backups, without even restoring them or risking loss of newer data.
• Document Databases into CHM or HTML (soon PDF and Word outputs as well).
• Discover unused objects and implement risk-free deletions.
• Integrate natively with popular source control systems like Subversion, VSS, and Team Foundation Server.
• And much more …