I'm interested in the existence of any tools which can perform static analysis against a SQL Server database. In essence, I'm looking for the DB equivalent of FxCop or NDepend; something which can inspect the data layer and come back with recommendations around metrics such as design, naming and any other measurable attributes relating to quality.
我对任何可以对SQL Server数据库执行静态分析的工具感兴趣。本质上,我正在寻找与FxCop或NDepend相当的DB;可以检查数据层并返回有关指标的建议,例如设计,命名和任何其他与质量相关的可测量属性。
Has anyone used a tool in the past that can provide some design feedback? Thanks.
过去有没有人使用过可以提供设计反馈的工具?谢谢。
3 个解决方案
#1
3
If you use SQL 2008, or have an instance of SQL 2008 anywhere, you can use policy based management. This will do what you want. Check Here This will work for naming and other standards, but might not work on data metrics.
如果您使用SQL 2008,或者在任何地方都有SQL 2008实例,则可以使用基于策略的管理。这将做你想要的。在此处查看这将适用于命名和其他标准,但可能不适用于数据指标。
You can alway use the Microsoft Best Practices analyzer for SQL
您始终可以使用Microsoft Best Practices Analyzer for SQL
#3
0
SQL Enlight is a dedicated static analysis tool for SQL Server, working in SSMS as well as part of Continuous Integration. There is a review on Simple Talk by Grant Fritchey. There are numerous built-in tests as well as a capability (albeit complicated looked) to author one's own checks.
SQL Enlight是SQL Server的专用静态分析工具,在SSMS中工作,也是Continuous Integration的一部分。 Grant Fritchey对Simple Talk进行了评论。有许多内置测试以及创建自己的检查的功能(尽管看起来很复杂)。
SQL Cop is another option. It's not as sophisticated as SQL Enlight, and can't be automated as part of a build process, but is free.
SQL Cop是另一种选择。它没有SQL Enlight那么复杂,也不能作为构建过程的一部分自动化,而是免费的。
#1
3
If you use SQL 2008, or have an instance of SQL 2008 anywhere, you can use policy based management. This will do what you want. Check Here This will work for naming and other standards, but might not work on data metrics.
如果您使用SQL 2008,或者在任何地方都有SQL 2008实例,则可以使用基于策略的管理。这将做你想要的。在此处查看这将适用于命名和其他标准,但可能不适用于数据指标。
You can alway use the Microsoft Best Practices analyzer for SQL
您始终可以使用Microsoft Best Practices Analyzer for SQL
#2
0
DataCleaner http://datacleaner.eobjects.org/
#3
0
SQL Enlight is a dedicated static analysis tool for SQL Server, working in SSMS as well as part of Continuous Integration. There is a review on Simple Talk by Grant Fritchey. There are numerous built-in tests as well as a capability (albeit complicated looked) to author one's own checks.
SQL Enlight是SQL Server的专用静态分析工具,在SSMS中工作,也是Continuous Integration的一部分。 Grant Fritchey对Simple Talk进行了评论。有许多内置测试以及创建自己的检查的功能(尽管看起来很复杂)。
SQL Cop is another option. It's not as sophisticated as SQL Enlight, and can't be automated as part of a build process, but is free.
SQL Cop是另一种选择。它没有SQL Enlight那么复杂,也不能作为构建过程的一部分自动化,而是免费的。