Love to code, although it bugs me.

PSMSSQL–Github Repository for MSSQL scripts in Powershell

No comments
github_logoThis post is to share with you a personal project with some work mates. PSMSSQL. This Github repository has scripts done in Powershell to interact with MSSQL databases.
It uses SQL Server Management Objects (SMO) to connect and interact with the remote database instances. You can read further on SMO at this URL: http://msdn.microsoft.com/en-us//library/ms162169.aspx
The first script submitted, "CompareMSSQLDB.ps1", takes the file "servers.txt" with a pair of server/database per line and compares the database identified on the first line against all other databases on the remaining lines.
Happy coding!


No comments :

Post a Comment