We have changed the table schema and we need to change the schema name in all the procedures that table being used dynamically instead of manual replace.

1 Answers

Roger Wolf On

If you would use SSDT for database development, you could utilise its refactoring capability of doing just that. Of course, any dynamic SQL will be left untouched, so if you have it in your code modules, you will need to search for it as usual.

If you don't plan to switch over to SSDT, you can create a database project, import schema from any existing database, perform any necessary refactoring and then deploy changes back to the database, either via a generated deployment script, or by using Schema Compare.