Greeting Gurus
whats the best way to automatically maintain synonym ?
Our manager suggests to use database trigger to do that ?
Our project is a Data warehouse project and there will be two schema.
One is a publishing schema that is for the user and the other is a next-release schema.
So at the release date, the next release schema will become the publishing schema
and the BI/Front End App will point to the NEW release schema
So now we need to create a synonyms and automatically sync them during the release.
Any input for this will really be appreciated.