title: change all synonyms to another database
body: <p>I have production database (for example, <code>PROD1</code>). It has a lot of synonyms to another database (for example, <code>PROD2</code>). </p>
  
  <p>I have created <code>PROD2_TEST</code> (as fully copy of <code>PROD2</code>) and also <code>PROD1_TEST</code> (as full copy of <code>PROD1</code>). But as a result I have <code>PROD1_TEST</code> synonyms to <code>PROD2</code>, instead of <code>PROD2_TEST</code>.</p>
  
  <p>How, can I automatically recreate all synonyms to the test database?</p>