Skip to content

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

License

Notifications You must be signed in to change notification settings

ScottWeinstein/PSIS

Repository files navigation

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

About

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

Resources

License

Stars

Watchers

Forks

Packages

No packages published