In SQL 2012, SQL Server powershell has been implement as module or individuals executable rather than a snapin.
There are 2 ways to run it. Import-module or just execute sqlps.exe
Interestingly, it is 32-bit only module.
When we load the sqlps module, it also include the cmdlet for SSAS.
Another way to run it is from SSMS.
If SQL database object has special character that can not be escape by powershell , we have to use this function to cover to the name that sql server can recognize .
For example, the table test t2:
We will get error when try to cd to it and needs to use
This is to covert the database object SMO urn path to the powershell path.