PSMSSQL–Github Repository for MSSQL scripts in Powershell
This 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!
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment