PowerShellDBDrive

Database Providers for Powershell to mount SQL Database as a Drive

Prerequisite

Easiest way is to install drivers into GAC either for Oracle or PostgreSQL.

Building

After cloning the project :

C:\PS> dotnet restore
C:\PS> dotnet build

Usage

For now, it's not package as a PowerShell module, so you have to load the DLL.

C:\PS> import-module .\PowerShellDBDrive.dll;

To mount an Oracle Database as a drive :

C:\PS> $ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host.company.org)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SID=OracleSID)));User Id=USERNAME;Password=PASSWORD;";
C:\PS> New-PSDrive -Name oracledb -PSProvider DatabaseProvider -Root "" -Provider Oracle.ManagedDataAccess.Client -ConnectionString $ConnectionString -Verbose

For now, only read (with some limitation) is supported :

oracledb:\> ls 
... [should return all schema/user]
oracledb:\> cd schemaname
oracledb:\schemaname> ls
... [should return all supported object types (table or view for now) of given schema]
oracledb:\schemaname> cd TABLE
oracledb:\schemaname\TABLE> ls
... [should return all the object of given type (all tables in this case)]
oracledb:\schemaname\TABLE> cd tablename
oracledb:\schemaname\TABLE\tablename> ls

Obviously, it's compatible with other PowerShell Commands.

This could be more efficient if we could give Get-ChildItem via dynamic parameters the columns to retrieve.

Filter support for Get-ChildItem would also be a nice feature to be add.

# This command should export the first 100 lines of tablename into a CSV using UTF-8 (with bom)
oracledb:\schemaname\table\tablename> ls | select -property Id,Name,SomeColumns | Export-Csv -NoTypeInformation -Path C:\Temp\Test.csv -Encoding UTF8

Database Supported

As of now, there are two target databases. (Could add more, but let's finish these first)

• Oracle (WIP)
• PostgreSQL (WIP)