November 4, 2004 at 10:48 am
Does anyone know of a utility / tool that will assist in renaming database objects (eg table, column, sproc, etc)?
Ideally you would be able to tell the tool the object whose name you want to change and its new name. The tool will rename the object and perform a "search and replace" on all references to the old object name with the new name.
This is such a common task that I'm surprised that a quick search on the internet does not turn up a dozen of competing tools.
Thanks in advance
Christian
November 8, 2004 at 8:00 am
This was removed by the editor as SPAM
November 8, 2004 at 9:41 am
Not so easy since the sysdepends information isn't dependable. I guess you could search out the code for all objects in sysobjects and perform an alter on all of them, but that would be cumbersome as well.
Don't know of a tool to do this.
November 8, 2004 at 9:59 am
Hi Steve,
Thanks for the reply. I've been doing a bit of digging around in this area. I've started trialling a tool called Speed Ferret - a tool dedicated to search and replace. I didn't notice this tool the first time around 'cause its main audience is Access developers. However, it also works with SQL Server 2000. I put it through its paces - I told the tool to change 6 table names along with their primary key columns and the tool searched the entire database changing the names of the objects AND fixing up all references to them in dependency order (nice)!
Another product that looks promising is ApexSQLEdit and ApexSQLDiff. I've got onto them and they are building a search and replace functionality into their IDE for sequel databases.
Christian
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply