SQL Server PowerShell Extensions

  •        0

The primary goal of SQL Server PowerShell Extensions (SQLPSX) is to provide intuitive functions around the SMO objects which are backward compatible with SQL 2000. A secondary goal is to provide an application which reports flatten/effective security settings.

http://sqlpsx.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

GetMsSqlDump - a mysqldump-like tool for MSSQL


GetMsSqlDump is the mssql counterpart (or something similar) of mysqldump, written for Microsoft SQL Server, in PowerShell. I'd call it mssqldump if it weren't in use. Using this script you can dump your database content into a file in a form of INSERT INTO statements.

Powershell4SQL


Module designed to simplify working with SQL Server from Powershell

posh-vm-manager - Powershell virtual machine management module


Powershell virtual machine management module

posh-josh - Custom powershell module with my own useful commands.


Custom powershell module with my own useful commands.

PowerRepl


A Powershell script to sync access database table data with SQL Server database tables.

WindowPowerShell - My configurations setup for powershell (PSCX, SQLPSX, etc)


My configurations setup for powershell (PSCX, SQLPSX, etc)

Powershell-pasen


My bag of powershell script for miscellaneous purposes. Like backing up all sql server database that starts with eCM or run all sql script recursively in a directory tree.

ReportingServicesTools - Reporting Services Powershell Tools


This project contains PowerShell scripts that allows you to perform various operations with SQL Server Reporting Services. In order to use the scripts included in this project successfully, please download/clone the entire project as there are dependencies between the scripts.All of our scripts were written with the assumption that you will be executing them against SQL Server 2016 Reporting Services default instance (i.e. mssqlserver). However, we understand this may not be the case for you. So for each script, you will see that we have provided a way for you to specify the name and/or version of your SQL Server Reporting Services instance name. Sometimes the version of your SQL Server instance is also required. If you do not provide one, we will assume that you want to execute this against the default instance.

PowerShell Data Processing Extension for SQL Server Reporting Services


Plug this into SQL Server Reporting Services to create reporting based on your PowerShell scripts. The PowerShell DPE transforms your PowerShell output into a DataSet that can be consumed by SSRS.

SQL Server DB & SSIS Powershell Deployment


A lightweight way to automate SQL Server builds and deploy SSIS packages to development environments. Uses Red Gate SQL Compare, SVN and Powershell. Ideal for DW/BI projects.

Posh-Hg


Mercurial integration for Windows Powershell

powerTrace - a PowerShell snapin for SQL Server Trace files


This is a snapin for Microsoft PowerShell which allows for the loading and exploration of SQL Trace files using PowerShell. This provider has been initially designed to work with trace files from SQL Server Analysis Services.

PortableConsole


Portable Console2 configured to run JPSoft TCCLE, Powershell, Posh-Git, Posh-Hg and Posh-Svn. Includes batch scripts to download and run portable versions of TCCLE, msysgit, TortoiseHg, and SlikSvn

Semantic-PoSH - PowerShell Module that eases the use of Intellidimension's Semantic SDK


PowerShell Module that eases the use of Intellidimension's Semantic SDK

posh-couch - A PowerShell module for CouchDB


A PowerShell module for CouchDB

Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server


SPADE simplifies the process of standing up a new SQL Server instance by applying standard Operating System pre-configurations, Installing SQL Server and then applying post-configurations and creating standard objects.

Epmf - PowerShell: Enterprise Policy Based Framework for SQL Server


PowerShell: Enterprise Policy Based Framework for SQL Server

PowerShell-ETL-SQL-Server


PowerShell scripts for more object-oriented ETL than SSIS & remote SQL Server job initiation

sqlBackupRestorePS - My simple MS Sql Server backup and restore Powershell script


My simple MS Sql Server backup and restore Powershell script