I'm looking for something akin to FxCop, but for databases. Basically, I want to have a tool where I configure my database standards (naming conventions, field types, or more complex custom rules). Then, I want to incorporate that tool into my continuous integration process so that any violations are flagged immediately.

We support both Oracle and SQL Server so tools that address either of those is good, but one tool that supports both would be better.

Do tools such as this exist or perhaps there is some better method or type of tool that I can utilize to help me achieve this goal?

@ElYusubov no I didn't look at that. If there are unit testing tools aimed at databases I suppose that might work, although it would probably be a bit more cumbersome than a tool that was specifically designed to be a validation rules engine.
–
RationalGeekJul 12 '12 at 19:25

1 Answer
1

If you can upgrade to Visual Studio Ultimate, you will be able to have Code analysis¹ for database projects as well, as well as integrate Code analysis in TFS build for your continuous integration. I'm unsure if Code analysis is available for Oracle, but I may check for it if you're interested.