Bit of info from my experience...

1)   MDS is a source control system. you do not need to use anything else. Production MDS is your versioned source control and...

To avoid risk of data loss due to primary dc failure you should add a new node in and get that up and running as a secondary in the AG....

We use dbghost and you can run this from the command line. It's a very good tool.

The only method I can see is creating a secondary TCP endpoint on a different port and assigning the Business Users access via this port and then locking this port...

I have found the magic setting... "ID"

If you click the source box of any of your data flow tasks and look at its properties there is a common property called...

cheers

Thanks Max... 🙂

Thanks Sandy,

works very nicely... 🙂

sorry... correct xml is now there...