GenXdev.Data.SqlServer provides comprehensive SQL Server database access from PowerShell. It mirrors GenXdev.Data.SQLite's cmdlet surface — schema discovery, table and view data retrieval, transaction management, query execution, and SSMS integration — providing a consistent experience across both database engines.
| Command | Aliases | What it does |
|---|---|---|
| New-SQLServerDatabase | nsqldb |
Create a new SQL Server database |
| Invoke-SQLServerQuery | — | Execute SQL queries with transaction support |
| Invoke-SSMS | ssms |
Launch SQL Server Management Studio |
| Get-SQLServerTables | — | List all tables in a database |
| Get-SQLServerTableSchema | — | Get the schema definition for a table |
| Get-SQLServerTableData | — | Retrieve rows from a table with optional limits |
| Get-SQLServerTableColumnData | — | Retrieve data from a specific column |
| Get-SQLServerViews | — | List all views in a database |
| Get-SQLServerViewSchema | — | Get the view definition |
| Get-SQLServerViewData | — | Retrieve rows from a view |
| Get-SQLServerSchema | — | Get the complete database schema at once |
| Get-SQLServerTransaction | getsqltx, newsqltx |
Create a transaction for batch operations |
New-SQLServerDatabase (nsqldb) creates a new SQL Server database.
Invoke-SQLServerQuery executes SQL statements. The schema discovery
cmdlets (Get-SQLServerTables, Get-SQLServerTableSchema,
Get-SQLServerTableData, Get-SQLServerViews, Get-SQLServerViewSchema,
Get-SQLServerViewData, Get-SQLServerTableColumnData,
Get-SQLServerViewColumnData, Get-SQLServerSchema) let you explore
database structure and data from PowerShell.
Get-SQLServerTransaction (getsqltx, newsqltx) creates a transaction
object for batch operations. Invoke-SSMS (ssms) launches SQL Server
Management Studio.
- GenXdev.Data.SQLite — SQLite counterpart with identical patterns
- GenXdev.Data.Preferences — Typed preferences system
- Full Cmdlet Reference