A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi, We are migrating our SQL data warehouse on new contract where we need to recreate all our sql objects like tables, table columns and store procedures with new name.
Here is example -
Table structure and store procedure logic will remain same so can i have any dynamic query which can migrate all sql objects with new name.
If there are not many objects that need to be modified, you can use the Generate Script Wizard in SSMS to output the scripts to a new query window or file, then use search and replace the old name with the new name.