Smart Renam multiple objects

danbocdanboc Posts: 23
edited May 6, 2008 7:09AM in SQL Refactor Previous Versions
Hi there!

I was wondering if it is possible to rename MULTIPLE objects in one go.

For example I have a set of tables prefixed with the word "Cust" and I want to change all of them to prefix with "Customer" (including column names). Is there a quick way to do this or do I have to go through table by table column by column?




  • The easiest way of doing this would be use SQL Compare against an empty database, and create a SQL script for the schema, and use a Search/Replace on the strings for creating the tables, then run the script. You could then use the same strategy with SQL Data Compare to insert the data into the tables.
    Chris Buckingham
    Red-Gate support
Sign In or Register to comment.