ApexSQL Diff Professional can take the advantage of using custom SQL scripts before and after the SQL database synchronization process, which further increases the application’s flexibility by reducing the need for the user to manually perform the required preparation and final actions necessary for successful synchronization.
March 19, 2013ApexSQL Search 2013 – Product update alert
ApexSQL Search 2013 has been released
Type: New version
About ApexSQL Search: ApexSQL Search is a FREE SQL Server Management Studio and Visual Studio add-in, which finds text in SQL database objects and data in SQL database tables and views. It allows changing tables, views, stored procedures, functions, columns, parameter names and schema without breaking dependencies, while visualizing all objects’ interdependencies. For more information visit the ApexSQL Search product page
March 19, 2013ApexSQL Refactor 2013 – Product update alert
ApexSQL Refactor 2013 has been released
Type: New version
About ApexSQL Refactor: ApexSQL Refactor is a FREE SQL Server Management Studio and Visual Studio add-in which formats SQL using nearly 200 formatting options and 11 code refactors. It expands wildcards, fully qualifies object names, renames SQL database objects and parameters without breaking dependencies and much more. For more information visit the ApexSQL Refactor product page
March 19, 2013ApexSQL Data Diff 2012 R2 – Product update alert
ApexSQL Data Diff 2012 R2 has been released
Type: Maintenance release
About ApexSQL Data Diff: ApexSQL Data Diff is a SQL Server data comparison and synchronization tool which detects data differences and resolves them without errors. It can compare and sync live databases and native or natively compressed database backups and generate comprehensive reports on the detected differences. For more information, visit the ApexSQL Data Diff product page
March 19, 2013ApexSQL Diff 2012 R2 – Product update alert
ApexSQL Diff 2012 R2 has been released
Type: Maintenance release
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
March 19, 2013ApexSQL Restore: the backup restore performance numbers are in
ApexSQL Restore attaches a SQL backup much faster than SSMS. We’ve measured and compared application performance to show its advantages over the SSMS and the leading competitor. Performance is determined by three key parameters: time needed, resources used and disk space consumed when restoring backups
March 18, 2013ApexSQL Data Diff 2012 data comparison performance improvement
ApexSQL constantly improves its tools by revising and optimizing their code and introducing new features/options. Regarding ApexSQL Data Diff 2012 vs ApexSQL Data Diff 2011, there have been significant performance improvements while using both approaches. Source code was modified and no major changes in behavior/GUI/options have been made. Also, new options were introduced that changed the tool’s behavior. The newly added options are Show equal rows, Use checksum for large values comparison and selective database re-comparison logic; their impact on ApexSQL Data Diff performance will be described later
March 11, 2013User defined SQL formatting profiles in ApexSQL Refactor
User defined SQL formatting profiles in ApexSQL Refactor
ApexSQL Refactor takes formatting to a new level, making maintaining a personal formatting style much easier in multiple-user environment or in companies with strict formatting requirements by allowing them to switch between different formatting styles in a single click.
March 5, 2013ApexSQL Diff has gone PRO: the scouting report
In order to meet the customer needs across environments and price ranges, ApexSQL decided to release two versions of ApexSQL Diff – ApexSQL Diff Professional and ApexSQL Diff Developer
The ApexSQL Diff Developer version will be a lite version of the tool, tailored to meet the demands of the users who do not need the full set of features which will be available in ApexSQL Diff Professional
March 1, 2013Using a centralized SQL auditing model
By default, ApexSQL Trigger stores all captured information in the audited database itself. However, a central repository database can be used for all audited data instead. The advantages of using a centralized SQL auditing model can be summed up as:
- Auditing maintenance advantages
- Audit reporting advantages
