Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Chad Miller

Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. Chad is the Project Coordinator/Developer of the Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is a frequent speaker at users groups, SQL Saturdays and Code Camps.

SQLPSX 2.3.2.1 Release

We’ve released a minor update to SQLPSX which includes includes several bug fixes/enhancements as well as one new module. Here’s an excerpt from the release notes:

Added MySQLLib Module

Mike Shepard created a MySQL module for querying MySQL databases. This is similar in concept to the adolib and OracleClient modules.

Modified adolib Module

  • Changed SQLBulkCopy to use System.Data.Common classes rather than SQLClient-specific classes for platform interoperability
  • Fixed issue in new-sqlcommand

Modified OracleClient Module

Added OracleBulkCopy which allows you to bulk load data into Oracle

Modified SQLServer Module

Added FileListOnly to Invoke-SqlRestore function

Modified PBM Module

Fixed issue in PBM module when writing to Windows Event log

Modified SSIS Module

Added ProtectionLevel parameter.  The package protection level can now be changed/specified as part of the copy process

Credits

My thanks to

  • Bernd Kriszio (blog|twitter) for his OracleClient enhancements as well as feedback on adoblib
  • Mike Shepard for adding functionality and maintaining his adolib as well as branching out SQLPSX to include basic query support for MySQL.
  • Eric Humphrey (blog|twitter) for contributing a patch to the SSIS module which adds support for specifying the package protection level during copy processes.

Comments

Posted by Jason Brimhall on 14 March 2011

Awesome - I hadn't heard of SQLPSX before but definitely need it.

Leave a Comment

Please register or log in to leave a comment.