Smart Renam multiple objects

danboc

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?

Thanks,

Daniel

chris.buckingham

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.