Here the senario:

We upgraded our production database and server from 32 to 64-bit. The testing server is still on 32-bit. The production server database was restored via a data dump.

My problem is that all the synonyms for a particular id are missing in the new production server. I don't want to rewrite hundreds of scripts to fully qualify all the tables and views.

My question: Is there a why to auto-generate the sql to recreate the synonyms in the test db and run it against the production db? I can't spend the time to create 629 synonyms individually.

Thanks.