Starting with Microsoft SQL Server Code-Named “Denali”, Community Technology Preview 3 (CTP 3), Windows PowerShell is no longer installed by SQL Server Setup. Windows PowerShell 2.0 is a pre-requisite for installing Microsoft SQL Server Code-Named “Denali”, Community Technology Preview 3 (CTP 3). If PowerShell 2.0 is not installed or enabled on your computer, you can enable it by following the instructions on the
Windows Management Framework page. For more information about SQL Server PowerShell, see
SQL Server PowerShell.
Microsoft SQL Server Code-Named “Denali”, Community Technology Preview 3 (CTP 3) now uses the new Windows PowerShell 2.0 feature called modules for loading the SQL Server components into a PowerShell environment. Users import the
sqlps module into PowerShell, and the module then loads the SQL Server snap-ins. For more information, see
Run SQL Server PowerShell.
The
sqlps Utility is no longer a PowerShell 1.0 mini-shell; it now starts PowerShell 2.0 and imports the
sqlps module. This improves SQL Server interoperability by making it easier for PowerShell scripts to also load the snap-ins for other products. The
sqlps utility is also added to the list of deprecated features starting in Microsoft SQL Server Code-Named “Denali”, Community Technology Preview 3 (CTP 3).
The SQL Server PowerShell provider includes two new cmdlets: backup-sqldatabase and restore-sqldatabase. For more information, use the get-help cmdlet after loading in the sqlps module.
Partager