ApexSQL Clean
Developer’s Description
ApexSQL Clean has been discontinued in favor of a new standalone database dependency analysis tool, ApexSQL Analyze
We apologize for any inconvenience to existing customers. Therefore, existing customers with current Support and Upgrades will still get dedicated customer support for the duration of their subscription
In with the new
We are offering continued dedicated support and free 1:1 migration path to ApexSQL Analyze. Simply email [email protected] to request your free key or, if you are an ApexSQL Developer/Universal customer, use the Resend keys form to automatically get the key added to your bundle and emailed to you
ApexSQL Analyze offers an improved version of the dependency analysis and visual presentation features of ApexSQL Clean, but doesn’t include the ability to find and remove unused objects aka “cleaning”
ApexSQL Analyze is equipped with an updated engine for SQL database graphical dependency analysis and allows exporting dependency diagrams to BMP, JPEG and PNG formats as well as dependency diagram customization and manipulation. Additionally, ApexSQL Analyze offers support for Azure SQL Database and Amazon RDS for SQL Server, support for SQL Server 2017, new GUI themes, and additional features than the latest version of ApexSQL Clean
For a brief look at ApexSQL Analyze and its features, see the following articles:
- What’s next in ApexSQL Developer: ApexSQL Analyze, graphical dependencies
- ApexSQL Analyze 2018 – Screen shot tour
We are currently engaged in an active development cycle for ApexSQL Analyze where we will be further improving quality, performance, usability, as well as adding features. We would appreciate any detailed feedback about the product and send us any bugs you find early and often we can arrange a complimentary license.
Publisher Description
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 2016 support (all other SQL Server versions are also supported 2014, 2012, 2008, 2005), so you can analyze SQL Server 2016 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.
Features:
– View and analyze SQL and client code dependencies
– Create and execute drop script
– Analyze external databases for dependencies
– Perform impact analysis on potential changes
– View object dependencies graphically
– Create and export reports from object dependencies
ApexSQL Clean is a tool designed to view database dependencies and analyze the impact of planned changes. ApexSQL Clean will analyze a client whether it is C#, ASP.NET, Delphi, etc. to determine what SQL objects are actually being used and what objects aren’t. It will also analyze the database itself to find the internal references that exist among SQL objects. Based on this analysis it will generate a file of SQL drop statements to remove these useless objects from your database.