Feedback on Smart Rename

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

Feedback on Smart Rename

Postby kondrich » Thu Aug 26, 2010 11:04 am

Smart Rename feature is really nice. I tried it on various objects and object types. Generated scripts look good.

However, it seems that only objects within the current database are considered for dependency checks, right? This would be a major drawback, since dependent objects in other databases/instances/servers would still get broken.

Will this feature get enhanced with cross-database/cross-server dependency checks until the final release?
Regards, Klaus
kondrich
 
Posts: 60
Joined: Thu Jun 10, 2010 10:44 am
Location: Vienna, Austria

Postby David Atkinson » Fri Aug 27, 2010 2:53 pm

This would be a great capability for the feature, but it's not something we can easily do for the next release.

In the meantime, you might want to consider using SQL Search to help identify references to your renamed object? It might come up with a few false positives as it's just a textual search, but may nonetheless save you significant time.

Kind regards,

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

Postby kondrich » Mon Aug 30, 2010 6:46 am

Yes, we are currently using SQL Search for this investigations. However, since it is a manual process, we are looking for automatic dependency searches.
Regards, Klaus
kondrich
 
Posts: 60
Joined: Thu Jun 10, 2010 10:44 am
Location: Vienna, Austria


Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 0 guests