Red Gate forums :: View topic - SQL Refactor for Delete and/or move Suggestion
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

SQL Refactor for Delete and/or move Suggestion

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



Joined: 13 Apr 2010
Posts: 11

PostPosted: Thu Sep 30, 2010 4:20 pm    Post subject: SQL Refactor for Delete and/or move Suggestion Reply with quote

I came across an issue today where I needed to move 2 columns from table A to table B.

I assumed SQL Refactor would at least have a "Smart Delete" function that would find all references and either notify me or remove them from those objects. I was disappointed when it wasn't there. I think this would be a nice addition.

It would have been even better for me to have been able to do a "Smart Move" where I could select the table I want to move the columns to. This isn't a "Split Table" as the other table already exists.
_________________
Jack Corbett
http://wiseman-wiseguy.blogspot.com
SQL Server DBA
MCITP: Database Administration SQL Server 2008
Back to top
View user's profile Send private message
David Atkinson



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

PostPosted: Sat Nov 06, 2010 7:07 pm    Post subject: Reply with quote

Regarding 'smart delete', although we don't have this feature, we've got SQL Search, which is a free tool that will allow you to identify references in your databases.

In the upcoming release of SQL Prompt 5, we will have a 'find invalid objects' feature which will identify those objects that reference objects that have since been deleted or renamed. This should help you to clean your database once objects have been removed.

Kind regards,

David Atkinson
Red Gate Software
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