/PSIS

Powershell based tools for SqlServer - Parallel bulk load, parallel star schema population, database source control and migrations

Primary LanguagePowerShellMIT LicenseMIT

Project Description

A set of tools aimed at ETL (Extract Transform and Load) tasks as well as DB version control and deployment.

For the ETL we are focused on getting the most common ETL tasks done without SSIS.

Following ELT features are supported

  • Bulk data transfer
  • Via ADO.Net
  • From Excel
  • From IEnumberable
  • Single Pass, multi-threaded Star Schema Populator
  • Extract data to .csv file

Following build and deployment features

  • Extract code
  • Deploy code and change files