Comments
Sort by recent activity
Thanks Eddie!
As a suggestion, make the API callable via TSQL (maybe through the CLR via a function taking OldName, NewName and ObjectType) such that the API returns the SQL Script necessary to preform the Smart Rename. Then we can pull all that together and execute it as a large script (or set of scripts).
For Instance, I'd like to be able to do the following.
1) loop through each table and column from a source that provides the old and new name.
2) for each old value, call Red Gate's API to get the SQL required to perform the Smart Rename.
3) sp_executeSQL the returned SQL.
4) loop to the next old/new item.
Thanks! / comments
Thanks Eddie!
As a suggestion, make the API callable via TSQL (maybe through the CLR via a function taking OldName, NewName and ObjectType) such that the API returns the SQL Script necessary to pre...