Change SQL Client Aliases

hi

we have database vendor not support sql mirroring.

in order have high-availability, use sql aliases on sql client. in case of failure, change sql alias point different server.

 

how make change via powershell?

use sql server wmi provider configuration. page discusses how delete or create aliases using wmi provider's sqlserveralias class powershell:

http://www.databasejournal.com/features/mssql/article.php/10894_3709441_2/microsoft-windows-powershell-and-sql-server-2005-wmi-providers--part-1.htm

i couldn't find examples on web altering alias.

the author of topic , writer have published book building powershell scripts sql server. paper version @ url, there e-book versions:

http://www.amazon.com/microsoft-administration-windows-powershell-programmer/dp/0470477288/ref=sr_1_1?ie=utf8&qid=1305920770&sr=8-1

 

 

---

alan brewer [msft] sql server documentation team posting provided "as is" no warranties, , confers no rights.

Windows Server  >  Windows PowerShell