Returns rows of data from database as PowerShell objects, rather than just one line of text data per row. This allows writing PowerShell code to perform operations involving different database instances or even different DBMS instances. For example, data can be merged from different DBMS or synchronized from one database instance into another DBMS instance. The original use case that prompted creating this code was synchronizing data in many edge MySQL instances with a centralized SQL Server instance.
Database Management Systems (DBMS) currently supported:
- Microsoft SQL Server
- MySQL from Oracle
- PostgreSQL
- Download the
DotNetData.ziparchive file. - Extract the archive under one of directories in
$env:PSModulePath, such asC:\Program Files\WindowsPowerShell\Modules.
See the files in the Examples directory for examples for each DBMS.
- Try out some of the test scripts located in the
Examplesdirectory. For each example script:- Edit the example with a specific server name and username
- Execute the test script in PowerShell