Export-DataTable.ps1

function Export-DataTable
{
    <#
    .Synopsis
        Exports objects to a datatable on disk
    .Description
        Exports objects to a datatable.  Objects in the datatable must be serialiazble in order to be stored.
    .Link
        Import-DataTable
    .Link
        ConvertTo-DataTable
    .Notes
        A datatable will not be able to be exported if it contains live objects that do not implement ISerializable.
    .Example
        dir | 
            select Name, LastWriteTime, CreationTime | 
            Export-DataTable -OutputPath .\Files.bin

        Import-DataTable .\Files.bin
    #>
    [CmdletBinding(DefaultParameterSetName='InputObject')]
    [OutputType([Nullable])]
    param(
    # The input object
    [Parameter(Mandatory=$true,ParameterSetName='InputObject', ValueFromPipeline=$true)]
    [PSObject[]]
    $InputObject,

    # An existing data table.  Use this parameter to store data tables created with New-DataTable
    [Parameter(Mandatory=$true,ParameterSetName='ExistingDataTable')]
    [Data.Datatable]
    $DataTable,

    # The output path
    [Parameter(Mandatory=$true,Position=0)]
    [string]
    $OutputPath
    )

    begin {
        # Create a collection to hold all objects
        $allObjects = New-Object Collections.ArrayList
        
    }

    process {
        #region Accumulate Input
        if ($PSCmdlet.ParameterSetName -eq 'InputObject') {
            $null = $allObjects.AddRange($InputObject)
        }
        #endregion Accumulate Input
    }

    end {
        # If input was supplied by the pipeline, convert it to a data table
        if ($allObjects.Count) {
            $DataTable = ConvertTo-DataTable -InputObject $allObjects
        }

        
        # Determine the absolute path of the output file
        $outFile = "$($ExecutionContext.SessionState.Path.GetUnresolvedProviderPathFromPSPath($OutputPath))"
        
        # Open the file stream
        $fileStream = New-Object IO.FileStream $outFile, "OpenOrCreate"                
        # Open a GZip stream on the file stream
        $cs = New-Object System.IO.Compression.GZipStream ($fileStream, [Io.Compression.CompressionMode]"Compress")
        
        # Serialize and save the data 
        (New-Object System.Runtime.Serialization.Formatters.Binary.BinaryFormatter).Serialize($cs, $DataTable) 
        
        # Close the compressed stream
        $cs.Close()
        # close the file stream
        $fileStream.Close()
    }
}