Suggestion - database integrity check

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

Suggestion - database integrity check

Postby CrispinH » Thu Mar 12, 2009 4:56 pm

When developing databases, particularly in the early stages, I frequently make large changes to the structure of tables and some of the stored procedures don't always catch up. It would therefore be useful to have an extension to SQL Refactor (or perhaps SQL Compare) where you can run an integrity check on the entire database to make sure that all is well before attempting to use SQL Compare to copy it to a test environment. SQL Compare does throw errors if the stored procedures contain invalid columns, so it should be a small step (?) to be able to list anomalies for the entire database.

Crispin
CrispinH
 
Posts: 38
Joined: Mon Nov 21, 2005 10:41 am

Postby David Atkinson » Thu Mar 12, 2009 5:02 pm

We're definitely considering something like this and there is a fair amount we could do in this area, checking for orphaned references being just one of them.

What else might you want to have checked?

Regards,

David Atkinson
Product Manager
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby CrispinH » Thu Mar 12, 2009 8:16 pm

In terms of fixing problems, tables missing a primary key is an obvious one. I'll think about other issues and post them later.

Crispin

[/list]
CrispinH
 
Posts: 38
Joined: Mon Nov 21, 2005 10:41 am

Postby CrispinH » Mon Mar 16, 2009 4:58 pm

I notice that something (probably SQL Prompt) underlines invalid columns in a stored procedure in red, so maybe having a menu option on SQL Refactor or SQL Prompt that allows the deletion of invalid columns would be a good start.
CrispinH
 
Posts: 38
Joined: Mon Nov 21, 2005 10:41 am


Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests