News  
  By product  

ApexSQL News

Product announcements, promotions and other ApexSQL news


ApexSQL Recover is ready for SQL Server 2012

We are happy to announce that ApexSQL Recover, our SQL database recovery solution, now fully supports SQL Server 2012 and all of its new objects, properties and enhancements

Here is an overview of what’s supported:

Database recovery

Full support for recovery from all SQL Server 2012 databases, including:

  • Contained databases created in SQL Server 2012
  • Non-contained databases created in SQL Server 2012
  • Non-contained databases created in earlier SQL Server versions

Recovery data sources

The following data sources can be used:

  • Online databases
  • Online transaction logs
  • Detached database files
  • Detached transaction log files
  • Transaction log backups
  • Database backups
to recover objects and data from both non-contained and contained databases. Data and objects created in earlier SQL Server versions and migrated to SQL Server 2012 can be recovered using transaction log and database backups created in SQL Server 2012 as well as detached database and transaction log files and transaction log and database backups created in earlier SQL Server versions


Now, in addition to non-compressed database and transaction log backups, natively compressed database and transaction log backups can be used as recovery data sources as well


SQL Server 2012 integration

All lost, missing or damaged data and objects can be recovered directly to a SQL Server 2012 database


Additionally, the generated SQL recovery script can be opened and successfully executed in SQL Server 2012 Management Studio


Recovering new SQL Server 2012 objects and data

The newly introduced SQL Server 2012 FileTable objects as well as their data can now be recovered by generating and executing a recovery script, or directly to a SQL Server 2012 database



FileTable schema and data recovery is completely transparent; FileTables’ schema is scripted like any regular table schema and FileTable data is recovered scripting the appropriate INSERT statements

Labels: ,

...


ApexSQL Log is ready for SQL Server 2012

We are happy to announce that ApexSQL Log, our SQL auditing and recovery solution, now fully supports SQL Server 2012 and all of its new objects, properties and enhancements

Here is an overview of what’s supported:

Database auditing

Full support for auditing all SQL Server 2012 databases, including:

  • Contained databases created in SQL Server 2012
  • Non-contained databases created in SQL Server 2012
  • Non-contained databases created in earlier SQL Server versions

Auditing data sources

The following data sources can be used:

  • Online transaction logs
  • Detached transaction log files
  • Transaction log backups
  • Database backups
to audit both non-contained and contained databases. Databases which have been created in earlier SQL Server versions and migrated to SQL Server 2012 can be audited using transaction log and database backups created in SQL Server 2012 as well as detached log files, transaction log and database backups created in earlier SQL Server versions


Now, in addition to non-compressed database and transaction log backups, natively compressed database and transaction log backups can be used as auditing data sources as well


SQL Server 2012 integration

Captured SQL Server 2012 login data including the user, host and application names are captured and stored into any specified database


Additionally, all information on audited operations can be exported to a SQL script which can be opened and successfully executed in SQL Server 2012 Management Studio


Auditing new SQL Server 2012 objects and properties

The following data sources can be used:

  • FileTables
  • Sequences
  • Columnstore indexes

Additionally, DDL changes on sequences used on tables created in earlier SQL Server versions are captured as well
Besides DDL operations, DML operations affecting FileTables are captured as well


All captured operations affecting the new SQL Server 2012 objects can be scripted, exported, replayed or undone just as any other operation

Labels: ,

...


Product update alert – ApexSQL Recover 2011 R2

ApexSQL Recover 2011 R2 has been released

Type: New version

About ApexSQL Recover: ApexSQL Recover is a recovery tool for SQL Server databases which recovers deleted, truncated, corrupted or damaged data. It recovers objects and data lost due to drop operations and restores both deleted and online BLOBs as files making it ideal for SharePoint recoveries. For more information visit the ApexSQL Recover product page



About this release:
  • Supports recovery from natively compressed transaction log and database backups
  • Full Microsoft SQL Server 2012 support including recovery of FileTable schema and data
  • A new time filter which allows specifying the timeframe in which the incident had occurred for faster recovery
  • Support for additional SQL server data storage types including vardecimal and FILESTREAM
  • Additional support for direct-to-database recovery for:
    • Data lost due TRUNCATE and DROP operations
    • Tables with missing user defined data type definitions
    • Tables containing calculated columns
    • Tables with missing schema definitions
  • Improved usability - Easier server-side components installation
  • ...and more

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Recover product page

Labels: ,

...


Product update alert – ApexSQL Log API 2011 R2

ApexSQL Log 2011 API R2 has been released

Type: New version

About ApexSQL Log API: ApexSQL Log API is an API which provides transaction log reading capabilities to your applications. It audits data and object changes that have affected your SQL Server database, including the ones that have occurred before the product was installed. It restores damaged or missing data and captures information on the user, application and host used to make each change. For more information visit the ApexSQL Log API product page



About this release:
  • Increased performance – up to 40% faster transaction log auditing
  • Undo and redo scripts can be created for DML changes
  • Supports auditing of natively compressed transaction log and database backups
  • Full Microsoft SQL Server 2012 support including auditing, replaying or undoing changes affecting:
    • FileTables
    • Sequences
    • Columnstore indexes
  • Improved usability - Easier server-side components installation
  • ...and more

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Log API product page

Labels: ,

...


Product update alert – ApexSQL Log 2011 R2

ApexSQL Log 2011 R2 has been released

Type: New version

About ApexSQL Log: ApexSQL Log is an auditing and recovery tool for SQL Server databases which audits, reverts or replays data and object changes that have affected the database, including the ones that have occurred before the product was installed. It restores damaged or missing data and objects and captures information on the user, application and host used to make each change. For more information visit the ApexSQL Log product page



About this release:
  • Supports auditing of natively compressed transaction log and database backups
  • Full Microsoft SQL Server 2012 support including auditing, replaying or undoing changes affecting:
    • FileTables
    • Sequences
    • Columnstore indexes
  • A new visual results filter which allows filtering by:
    • the time when the change occurred
    • a specific DML or DDL operation
    • the objects affected by the change
    • the user, application and host used to make the change
    • the duration of the transaction
  • Improved scalability – up to 10 million operations can be displayed at once
  • Improved performance - operations are displayed immediately, without waiting for the auditing sources to be fully processed
  • Improved usability - Easier server-side components installation
  • ...and more

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Log product page

Labels: ,

...


Product update alert – ApexSQL Edit 2011 R2

ApexSQL Edit 2011 R2 has been released

Type: New version

About ApexSQL Edit: ApexSQL Edit is an integrated SQL development environment providing auto-complete, source control integration, SQL code debugging, profiling, formatting and refactoring. It visualizes objects' interdependecies and allows visual SQL query building. For more information visit the ApexSQL Edit product page



About this release:
  • Performance improvements:
    • Auto-complete loads up to 50% faster
    • Up to five time faster database connectivity
    • Up to 8% faster syntax highlighting
  • Full SQL Server 2012 including support for:
    • Columnstore indexes
    • Geometry and geography auto grid tessellation scheme for spatial indexes
  • Additional auto-complete suggestions including:
    • Labels for GOTO statements
    • INFORMATION_SCHEMA schema, objects and columns
  • Automatic synchronization between live objects and their versioned scripts
  • Object search supports searching for system databases and objects
  • ...and more

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Edit product page

Labels: ,

...


Product update alert - ApexSQL Diff 2011 R2

ApexSQL Diff 2011 R2 has been released

Type: New version

About ApexSQL Diff: ApexSQL Diff is a SQL Server database comparison and synchronization tool which detects differences between database objects and resolves them without errors. It generates comprehensive reports on the found differences and can automate the synchronization process between live and versioned databases, backups, snapshots and script folders. For more information visit the ApexSQL Diff product page



About this release:
  • Natively compressed SQL database backups can be used for comparison and synchronization
  • Full SQL Server 2012 support including comparing and synchronizing:
    • FileTables
    • Sequences
    • Search property lists
    • Columnstore indexes
    • Poison message handling attribute for queues
    • Geometry and geography auto grid tessellation scheme for spatial indexes
  • Usability improvements – faster comparison results browsing with the newly introduced Navigation bar
  • ...and more

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Diff product page

Labels: ,

...


Product update alert - ApexSQL Data Diff 2011 R2

ApexSQL Data Diff 2011 R2 has been released

Type: New version

About ApexSQL Data Diff: ApexSQL Data Diff is a SQL Server database comparison and synchronization tool which detects data differences and resolves them without errors. It can compare and sync live databases and database backups and generates comprehensive reports on the detected differences. For more information, visit the ApexSQL Data Diff product page



About this release:
  • Natively compressed SQL database backups can be used for comparison and synchronization
  • Full SQL Server 2012 including comparing and synchronizing data stored in FileTables and columnstore indexes
  • Support for additional SQL Server data storage types including FILESTREAM and SPARSE columns
  • Usability improvements on options and warnings
  • ...and more

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Data Diff product page

Labels: ,

...


SQL Server 2012 support roadmap

We wanted to make sure that enthusiasts and early adopters can take advantage of the benefits the latest SQL Server version offers. Ever since SQL Server Denali CTP1 was released, we worked hard to add support for the latest SQL Server version in parallel to its development. We updated our products for CTP1 and CTP3 shortly after their availability. This effort has culminated in our current level of SQL Server 2012 support that we offer.

Today, all ApexSQL products offer support for Microsoft SQL Server 2012 R1




SQL Server 2012 ready

We’ve implemented two levels of SQL Server 2012 support:
  1. Basic – The same level of support as for SQL Server 2008 R2 with new constructs for existing objects but without new objects for all data source types
  2. Advanced – Support for all new SQL Server 2012 objects, properties and enhancements including:
  • Contained databases
  • FileTables
  • Search property lists
  • Sequences
  • Columnstore indexes
  • Poison message handling attribute for queues
  • Geometry and Geography auto grid tessellation scheme for spatial indexes
  • User accounts created using Windows principal
  • User accounts created with passwords
  • New database properties
  • Encrypted object support
  • Support for SQL Server Integration Services 2012 packages
  • SQL Server 2012 Management Studio support and integration
All new products like ApexSQL Build and ApexSQL Restore will offer advanced SQL Server 2012 support right 'out of the box'

 Database administration

Basic Advanced
ApexSQL Log
ApexSQL Recover

 SQL development


ApexSQL Audit
ApexSQL Clean
ApexSQL Data Diff
ApexSQL Diff
ApexSQL Diff API Q2 2012
ApexSQL Doc Q2 2012
ApexSQL Edit
ApexSQL Script Q2 2012

 Add-ins


ApexSQL Complete
ApexSQL Profile
ApexSQL Refactor Q2 2012
ApexSQL Version Q2 2012

 Programmable APIs


ApexSQL Diff API Q2 2012
ApexSQL Log API

Labels:

...