I recently joined a company, who is looking to another way to synchronize their AlwaysOn clusters.
Currently, they are using a mix of powershell scripts which script out jobs to .sql file, buffer database for login transfer (backup/restore) and network share.
It is very heavy to set up, as they have to edit every scripts, create several network share (to script out jobs, for example), or create all jobs related to this synchronization. Moreover, error handling is very bad
First of all, i'm planning to activate "CONTAINED" feature on their newly database, to avoid login synchronization in the future.
Secondly, I'm wondering what is the best way to synchronize all the other things (logins, jobs and linked servers. We are no using other things concerned by AlwaysOn synchronization such as End Points or Ressource pool). Do PowerShell (without scripting out jobs in network share, but transferring it using SMO or something like that) or SSIS are liable solution ?
A friend a mine is using Orchestrator in order to do this.
( Does Microsoft keep this functionally for upcoming releases ? )