Mass table rename

sinaril

I was looking at Smart Table rename under 

Refactoring Databases with SQL Prompt

But I have few hundred table to rename, so I was hoping to feed into the process. SQL Compare has some command line interface wondering if this one has it too.

Jon_Kirkwood

Hi @sinaril

Regarding your query, there isn't a way to generate the scripts more quickly at the moment, I'm very sorry to say.

I have located a feature request for the option to do a bulk smart rename here - https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/1807089-bulk-smart-rename

Can you kindly vote on the feature and add a comment to it if you'd like? Our product managers use this as an important resource when considering new features. 

Thank you and apologies for the lacking feature!