ApexSQL Clean
General
|
Can I save my projects and options for future reference?
|
Yes. If you save your project - your option will be saved
If you change your project Source and Destination - your options will be reset to default
|
|
I'm having display problems because of the large number of objects. Can I group and sort them?
|
|
|
ApexSQL Clean identified un-referenced objects in my database. How can I safely remove these objects?
|
Use the Clean script Generation wizard. It will generate a script which will automatically remove all selected un-referenced objects
|
|
Can ApexSQL Clean show which columns participate in a dependency relationship?
|
Yes. ApexSQL Clean can show column level dependencies
|
|
Can ApexSQL Clean identify dependencies for dynamic SQL in objects like stored procedures and functions?
|
|
|
Can ApexSQL find external references to objects in different databases?
|
Yes, select the referenced database as the external database. The external database has to be on the same SQL Server instance
File analysis
|
|
Can I analyze my .NET projects or other client code (Delphi, C++, ASP, etc.) for database?
|
Yes .NET projects or other client code (Delphi, C++, ASP, etc.) can be analyzed
|
|
I would like my searches for objects in source code files to be case sensitive. How can I do that?
|
Use the Match case option. Note that this affects only search within client application source code files. Searches within SQL Server objects are NOT affected by this setting
Dependency viewer
|
|
Can I see a visual representation of the dependency analysis?
|
Yes. ApexSQL Clean has a powerful Dependency viewer based on its own parsing technology
|
|
What export/save options do I have in the Dependency viewer?
|
Dependency viewer image can be saved to a variety formats such as .jpg, .bmp, .gif, or .png. It can also be printed directly
|
|
Can I change the look and appearance of objects in the Dependency viewer?
|
Command line interface
|
|
I have a large and busy database I want to check for references. But I don’t want any unnecessary workload on that database during peak usage hours. Can I schedule a job to start the dependency analysis in off-peak hours?
|
Yes, use ApexSQL Clean command line interface. Create a *.bat file and schedule its execution as a SQL Server job or a Windows task
|
|
The command line operation of ApexSQL Clean requires that I provide a bit-wise value for determining which object types are to be documented. How can I determine that value?
|
The bit-wise value for object type selection is displayed in Object Filter in ApexSQL Clean GUI