PowerShell module to provide a better Admin oriented DSC Pull Server experience.
Clone or download
bgelens Release fix for Copy-DSCPullServerAdmin (#42)
* fix Copy-DSCPullServerAdminData reports using all switch instead of top (#41)
Latest commit 3f312d9 Nov 22, 2018



master dev psgallery
Build status Build status PowerShell Gallery
codecov codecov

A module to work with the DSC PullServer EDB (ESENT) and SQL database and provide a better Admin oriented Pull Server experience.

Update 11/20/2018: As of version 0.3.0, the module is able to handle the EDB with all features again. Get/Set/Remove/New is (in experimental) support!

The module enables you to move data from the EDB database to a SQL database. This allows you to "upgrade" your Pull Server implementation to make use of the SQL backend introduced in Windows Server RS4 (1803) and Server 2019. It ais also capable of doing migrations from SQL to SQL and EDB to SQL as of version 0.3.0!

The module supports accessing, manipulating, removing Devices (Legacy LCMv1, ConfigurationId), Registrations (LCMv2, AgentId) and StatusReports (LCMv2). All this data can be easily moved over to SQL as well.

Initially, the mdb database was also in scope for this module to process but unfortunately the required odbc driver is 32 bits only. For now mdb is out of scope.

Note that the current state of this module is very alpha / experimental. Use at your own risk and if possible always create a backup!


A big thank you goes out to @rdbartram and @gaelcolas who both brought in some major contributions. Thank you both!



Connect with EDB (the database cannot be in use by another process!) and get Devices and Registrations out of it.


Get StatusReports out of the EDB.




Connect with SQL and Get, Set, Create and Remove data.




Copy Data EDB to SQL

All data can be copied over.

Note, the function has been renamed to Copy-DSCPullServerAdminData as it is now capable of handling SQL to SQL, SQL to EDB, EDB to SQL and EDB to EDB



Class diagram

This project is PowerShell class based. Find here the Class diagram structure: