In order to use SQL SMOs on a server where SQL is not already installed, download and install the following SQL Feature Packs for whatever version you’re using, in the order listed:
1–Microsoft System CLR Types for Microsoft SQL Server
2–Microsoft SQL Server Shared Management Objects
3–Microsoft Windows PowerShell Extensions for Microsoft SQL Server
Before you can add assemblies in your script, you’ll need to reboot the server where the Feature Packs were installed.
To add assemblies, use the Add-Type command:
Add-Type -Assembly Microsoft.SqlServer.SMO