change all synonyms to another database
I have production database (for example, PROD1). It has a lot of synonyms
to another databae (for example, PROD2).
I have created PROD2_TEST (as fully copy of PROD2) and also PROD1_TEST (as
full copy of PROD1). But as a result I have PROD1_TEST synonyms to PROD2,
instead of PROD2_TEST.
How, can I automatically recreate all synonyms to the test database?
(SQL SERVER 2008)
No comments:
Post a Comment