ApexSQL Clean analyzes SQL Server database objects, dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself. ApexSQL Clean helps you remove unwanted objects risk free, map dependencies down to the table column level, specify database processing criteria, check or ignore the relationships for specific objects. You can also schedule unattended SQL dependency checking using the command line interface and create end-user reports to document the interdependencies in your environments. ApexSQL Clean comes with SQL Server 2012 support (all other SQL Server versions are also supported - 2008 R2, 2008, 2005 and 2000), so you can analyze SQL Server 2012 object relationships and identify FileTable, sequence, search property list, column, store index, poison message, handling attribute for queues, as well as geometry and geography auto grid tessellation scheme for spatial indexes dependencies.
Download now
ApexSQL Audit allows you to seamlessly integrate data auditing and reporting into your client applications, it can help you audit and undo SQL database changes and easily determine who and when changed the data. ApexSQL Audit is compatible with all SQL Server 2012, 2008 R2, 2008, 2005 and 2000 databases, it enables you to schedule unattended report generation via the command line interface, quickly identify unauthorized or malicious change, create end-user reports to document the changes in your environments, isolate specific operations by user, date, object, change type and more. With ApexSQL Audit you can translate audit data to information with watches and lookups, find out exactly when and how an accident occurred, details on who was involved, as well as monitor table definition changes.
Features:
- Store auditing data in a central, easy to manage repository
- Display only the operations that meet the criteria that you specify
- View all historical modifications to a specific row of data
- View gran ...
Download now
ORTWIN is a program for the inquiry of localities, postal codes and telephone selections in Germany. It finds coordinates and ground level elevations, municipal codes, local center points, car license codes, topographic maps, Unlocodes and much more. It arranges localities hierarchically in different administrative units. It performs perimeter searches and distance calculations. It finds landscapes, natural units and snow- and wind load zones.
Download now
ApexSQL Profile profiles SQL code directly in SSMS. Find out how long each SQL statement takes to execute visually. Identify bottlenecks at a glance. View parameters and variable changes over time and find out the exact lines where those changes occur. Determine how the variable values change during code execution. Identify the lines that take the longest to execute.
Performance profile SQL code directly in SSMS
Identify inefficient SQL code at a glance
Analyze code performance at line level
Track variable and parameter history
Features
- Lazy profiling
- Visual line-by-line profiling
- Execution history
- Performance details
- Customizable profiling
- Transparent decryption
- Quick navigation
- Comprehensive reports
- Support for all SQL Server versions
Download now
ApexSQL Data Diff is a SQL Server database comparison tool used to compare and synchronize database data and manage database version control. It also supports comparing database backups, CLI. It can automate and schedule database migrations, propagate data changes from one environment to another, identify and repair lost and/or damaged data, perform row level recovery from SQL backups without restoring. In case something goes wrong ApexSQL DataDiff can reverse any changes made by automatically creating a backup prior to database synchronization. With this tool you'll be able to create sophisticated reports to document the differences between your SQL Server databases and database backups and schedule your migration unattended, using the Command Line Interface
Features:
- Selectively limit what will be compared and synchronized with advanced filtering
- Specify comparison criteria. Create custom comparison keys
- Build complex filters to compare and sync specific data
- Save your options to a pro ...
Download now
ApexSQL Complete can automatically fill in SQL keywords, statements and identifiers. It integrates seamlessly with SSMS and VS. ApexSQL Complete helps with object script and description reviews without coding interruption and also speeds up SQL coding with snippets. This free SSMS and VS addin can quickly reference the object?s script and description inline, format keywords and fill in fully qualified object names automatically, highlight SQL coding errors as you type.
With ApexSQL Complete you can also:
- Auto-complete SQL code directly in Visual Studio 2012
- Identify the structure of complex SQL queries at a glance
- Format auto-completed keywords in upper, lower or proper case
- Specify aliases to be filled in for objects from all SQL Server instances and databases
- Boost auto-complete performance with object caching
- Auto-complete SQL 2012, 2008 and 2005 objects and keywords
- Auto-complete in Visual Studio 2012, 2010, 2008 and 2005