SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Best way to synchronize replicas in AlwaysOn Cluster


Best way to synchronize replicas in AlwaysOn Cluster

Author
Message
Dam_DBA
Dam_DBA
SSC Veteran
SSC Veteran (279 reputation)SSC Veteran (279 reputation)SSC Veteran (279 reputation)SSC Veteran (279 reputation)SSC Veteran (279 reputation)SSC Veteran (279 reputation)SSC Veteran (279 reputation)SSC Veteran (279 reputation)

Group: General Forum Members
Points: 279 Visits: 389
Hi everyone,

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 ? )
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search