All geek questions in one place

Can I use PowerShell with SQL Server 2005?

I know that SQL Server 2008 has unveiled some PowerShell functions as snapins. Now I want to know if I can use PowerShell with SQL Server 2005? I think the answer is NO , right? Thank.

+3
source share
1 answer

Yes. You can use PowerShell with SQL Server 2005. Minishell SQL Server 2008, sqlps.exe, which comes with SQL Server 2008, works with 2005 and even 2000 servers.

To get sqlps, you need to either install SQL Server 2008 Management Studio, or sqlps is available as a separate download as part of the Feature Feature Pack of SQL Server 2008

, PowerShell , SQL Server (SMO). SMO , SSMS sqlps, SQL Server 2005. sqlps, SMO SQL Server 2000.

CodePlex, , SQL Server PowerShell, 130 SMO PowerShell, R2 2000 R2 SQL Server.

+7

Source: https://habr.com/ru/post/1750045/

More articles:


All Articles