ZenArchitect.NL (Henk van Dijken)

Tweet

Do you know FxCop?

FxCop is an application that analyzes managed code assemblies. Many of the issues concern violations of the programming and design rules set forth in Design Guidelines.

Today, I announce my wish for an equivalent for SQL Database Analysis.

As it happens over time a database structure grows, and grows. Sometimes, it grows like wild grass. At other times, the database is restructured by someone who smoked to much wild grass.

There are two problems here:

1. it is difficult to know in which shape the database its structure is,
2. you are desperately in ***need** of serious tooling.

For .NET code you can use FxCop or StyleCop, but serious tooling is lacking for databases.

Therefore – all you tool belt lovers – lets unite and demand for a tool called SqlCop.

Tweet

To start with, you are desperately in need of a database migration toolkit.

That’s all.