Ok so please tell me if I am understanding this correctly: Say all tables & stored procedures in my source environment follow the schema names "source." and in my destination environment it is "dest." So after I restore to the destination environment, I will have to

(a) First change all objects which begin with source.xyz to dest.xyz. (It is a requirement to have destination schema names be different than source). This will take care of the object names, but the code in the SP's still points to source.xyz.

(b) So to circumvent that, I will have to create synonyms for all objects named source.xyz and point these to dest.xyz

Is this correct? If so, how can I go about creating the synonyms? I have a couple of hundred SP's so that's a lot of synonyms.