Red Gate forums :: View topic - Finding opportunities to refactor
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

Finding opportunities to refactor

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



Joined: 23 Apr 2010
Posts: 1
Location: London, UK

PostPosted: Fri Apr 23, 2010 1:55 pm    Post subject: Finding opportunities to refactor Reply with quote

So, I have a legacy database that I need to maintain. Changes are allowable, and in fact desirable - no grand re-writes here. However, just finding out which parts are still used is, well, _hard_.

One of the techniques I'd like to get some kind of tool support for is to get a summary of all of the columns of a table (or, why not all tables) that meet a set of criteria - like:
* all values in the row for the column are null
* the column only has a single value in it (so is unnecessary)
* the column only has a single value in it, when the row-set is restricted to the last x that were inserted to the table (ie, the column has _become_ unnecessary within some timeframe dictated by the range of table-rows)
* column usage does not show up in a given sql-profiling session
* column usage does not show up in a given other-profiler-tool session (eg nhprof)

This would allow me to target my software-archeology efforts within the applications on top of the database, and let me trim out the cruft that much quicker.

I don't know if Data Compare can already do this, but I think that my use-case is more refactoring-oriented, so I decided to post here.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 663
Location: Cambridge

PostPosted: Mon Apr 26, 2010 10:35 am    Post subject: Reply with quote

Many thanks for your post.

SQL Refactor is designed to Refactor the schema hence cannot serve the purpose in the mentioned scenario at the moment neither will Data Compare.

I have logged this as a feature request in our internal tracking system whose tracking id is SR-882.

I will update you as soon as it is incorporated.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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