ApexSQL News

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 Recover, SQL 2012

...

posted on Tuesday, May 22, 2012

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: ApexSQL Log, SQL 2012

...

posted on Tuesday, May 22, 2012

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: ApexSQL Recover, Product Updates

...

posted on Friday, May 18, 2012

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: ApexSQL Log API, Product Updates

...

posted on Friday, May 18, 2012

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: ApexSQL Log, Product Updates

...

posted on Friday, May 18, 2012

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: ApexSQL Edit, Product Updates

...

posted on Friday, May 18, 2012

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: ApexSQL Diff, Product Updates

...

posted on Friday, May 18, 2012

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: ApexSQL Data Diff, Product Updates

...

posted on Friday, May 18, 2012

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:

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
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: SQL 2012

...

posted on Tuesday, May 15, 2012

Products	Download	Purchase	Support	News	Company
Value bundles	Installer	PDF price list	Support center	Blog	Why ApexSQL?
Database administration	Pre-releases	License	Support forum	What's new	Jobs
SQL development	System requirements	Resellers	Support FAQs	What's next	Gear
Add-ins	Version information	Competitive upgrades	Troubleshooting	Press releases	Contact us
Programmable APIs			Knowledgebase	Product updates
All ApexSQL tools			Documentation
			Product videos