Fast1data.SqlServer

Fast1data.SqlServer is a PowerShell module for SQL Server administration and deployment workflows. It currently provides:

• Fast1 Audit — resumable import of SQL Server Audit (.sqlaudit) files into a SQL Server database.
• Fast1 Migration — ordered, checksum-protected execution of SQL Server migration scripts.
• Fast1 Archiving — resumable, batch-based archiving and purging between SQL Server databases.

Requirements

• PowerShell 7.4 or later
• SQL Server PowerShell module SqlServer module
• An x64 Windows, Linux, or macOS runtime
• Network and database permissions required by the selected feature

The module bundles Microsoft.Data.SqlClient for these runtime identifiers:

• win-x64
• linux-x64
• osx-x64

Install from source

Build the bundled SQL client libraries if lib is not already populated:

.\build\build.ps1

Import the module directly from the repository:

Import-Module .\Fast1data.SqlServer\Fast1data.SqlServer.psd1 -Force

Confirm that the public commands are available:

Get-Command -Module Fast1data.SqlServer

Features

SQL Server Audit import

Use Invoke-Fast1Audit to discover audit files, import new records, and resume from stored file offsets.

See Fast1Audit.md for database setup, permissions, ignore rules, and usage.

SQL Server migrations

Use Invoke-Fast1Migration to execute scripts in configured order, record their checksums, preview changes with -WhatIf, and selectively ignore or force scripts.

See Fast1Migration.md for schema setup, configuration, execution behavior, and CI/CD examples.

SQL Server archiving

Use Invoke-Fast1Archiving to copy and optionally purge configured table data in resumable batches.

See Fast1Archiving.md for prerequisites, database setup, table-group configuration, limitations, and usage.

Help

PowerShell command help is available after importing the module:

Get-Help Invoke-Fast1Audit -Full
Get-Help Invoke-Fast1Migration -Full
Get-Help Invoke-Fast1Archiving -Full

License

This project is licensed under the MIT License.