Tell me more ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.
up vote 7 down vote favorite

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?

share|improve this question
+1 for question. Did you looked at unit testing in DB? is this link helpful - agiledata.org/essays/databaseTesting.html – ElYusubov Jul 12 '12 at 19:24
@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. – RationalGeek Jul 12 '12 at 19:25
Have you looked at SQLCop? sqlcop.lessthandot.com – HLGEM Jul 12 '12 at 21:01

1 Answer

up vote 1 down vote

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.

Additionally to the existent rules, you can also write your own rules too.

Below, you can see a screenshot of a tab in the properties of an SQL Server 2008 Database Project:

enter image description here

¹ Code analysis is the same thing as FxCop, but provided with Visual Studio Ultimate and already integrated directly into it, rather than being a standalone tool.

share|improve this answer
2  
@downvoter: can you, please, explain what was difficult to understand in my answer, to let me improve it? Without a hint, I can hardly make the answer better. – MainMa Apr 12 at 19:08
code analysis is in premium edition too, not sure if the data part of it is as well. – jk. Apr 15 at 13:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.