I’ve created a PowerShell script for adding, updating, enumerating und removing SQL Server aliases. – You can use the script to create/remove/enumerate both 32bit und 64bit aliases in one step or only 32bit or only 64bit aliases.
You can change this script into a PowerShell module. Just see the comment below inside the script.
I’ve tested the script on Windows Server 2008 R2 with SQL Server 2008 R2 on it. – Please post your comments how it works on other systems.
Here is the script:
#region Author: Ingo Karstein / Blog: blog.kenaro.com