This PowerPack requires PowerGUI 1.5.1 or later and SQL Server 2008 RC0 or later. Earlier versions of SQL Server 2008 are not supported due to a name change in the SQL Server 2008 snapins.
This PowerPack allows you to manage local and remote SQL Server instances. It uses the SQL Server 2008 provider to allow you to browse through the SQL Server instances and it uses the SQL Server 2008 cmdlets to allow you to open any table or view and see all of the contents. When viewing table or view contents, you will be prompted to select between 10, 100, 1000 or all rows.
The SQL Server 2008 provider allows users to manage and view a huge amount of information related to SQL server, including tables, views, stored procedures, roles, logins, log files, rules, users, policies, and much more. It wraps SMO, so SQL 2005 and SQL 2008 databases are all supported. The only requirement other than PowerShell and PowerGUI is the SQL 2008 Client tools to get the required PowerShell snapins on your system for this PowerPack to work properly.
New functionality to this version of the PowerPack includes:
- more logical browsing of SQL server instances
- support for adding and remove connections to SQL servers
- prompting for the number of rows to be returned when opening a table or a view
- ability to see all related views or tables when looking at the schema list
- links to facilitate viewing views, tables, and schema across multiple servers or instances
- support for marking servers you connect to as test or production
So far I'm still just scratching the surface with this version of the PowerPack in terms of what can be done. If there is specific functionality that you are looking for in this, please let me know so that I can make sure it is on my list for future updates.
|
