Red Gate forums :: View topic - Suggestion - database integrity check
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Refactor 1
SQL Refactor 1 forum

Suggestion - database integrity check

Search in SQL Refactor 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
CrispinH



Joined: 21 Nov 2005
Posts: 38

PostPosted: Thu Mar 12, 2009 4:56 pm    Post subject: Suggestion - database integrity check Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Thu Mar 12, 2009 5:02 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
CrispinH



Joined: 21 Nov 2005
Posts: 38

PostPosted: Thu Mar 12, 2009 8:16 pm    Post subject: Reply with quote

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]
Back to top
View user's profile Send private message
CrispinH



Joined: 21 Nov 2005
Posts: 38

PostPosted: Mon Mar 16, 2009 4:58 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group