Skip to content
Marco van Gaal edited this page May 19, 2015 · 12 revisions

NAME

Invoke-SQLiteFill

SYNOPSIS

Bulk insert <DataTable> to SQLite Table.

WARNING: this will overwrite all Rows in table

DESCRIPTION

PARAMETERS

-Connection Required? true Position? 1 Default value
Accept pipeline input? false Accept wildcard characters? false -InputObject Required? true Position? 2 Default value
Accept pipeline input? false Accept wildcard characters? false -Name Required? true Position? 3 Default value
Accept pipeline input? false Accept wildcard characters? false -Whatif [] Required? false Position? named Default value False Accept pipeline input? false Accept wildcard characters? false

INPUTS

None. You cannot pipe objects to Invoke-SQLiteFill.

OUTPUTS

Count of rows inserted to SQLite Table

EXAMPLES

-------------------------- EXAMPLE 1 --------------------------
C:\PS>Invoke-SQLiteFill -conn <SQLiteConnection> -InputObject <DataTable> -Name <String>
Fills Table in SQLite (WARNING: this will overwrite all Rows in table)

-------------------------- EXAMPLE 2 --------------------------
C:\PS>Invoke-SQLiteFill -conn <SQLiteConnection> -InputObject <DataTable> -Name <String> -WhatIf
Creates SQLite transaction inserts rows and then rollsback the transaction

RELATED LINKS

http://www.proxx.nl/

Clone this wiki locally