About once a month we take the backups from our Dev servers and restore them to our Stage server.
However after the restore, all of the synonyms are now incorrect on the stage database.
What is the best way to handle this? Not sure if i am just missing something simple.
Should I just script them out before the restore and recreate them after the restore, or is there a way that they can automatically change based on the Database name?