Get-QLRSqlCommand

From PowerGUI Wiki

Reads DML/DDL commands.

Contents 1 Syntax 2 Detailed Description 3 Related Commands 4 Parameters 5 Input Type 6 Return Values 7 Examples 7.1 EXAMPLE 1 7.2 EXAMPLE 2

Syntax

Get-QLRSqlCommand [-Reader] <LogReaderSSWrapper> [-After [<DateTime>]] [-Before [<DateTime>]] [<CommonParameters>]

Detailed Description

The Get-QLRSqlCommand cmdlet reads DML/DDL commands from an open LogReader object and writes then to a pipeline.

Related Commands

• New-QLRSqlReader
• Get-QLRSqlRecord
• Get-QLRSqlTransaction

Parameters

Name	Description	Required?	Pipeline Input	Default Value
Reader	The open LogReader object. This object should be created by the New-QLRSqlReader cmdlet.	true	false
After	The first date in the log to read commands. Log Reader will read all commands in the log that were executed after this date.	false	false
Before	The last date in the log to read commands. Log Reader will read all commands in the log that were executed before this date.	false	false

Input Type

Quest.LogReader.SqlServer.Wrappers.LogReaderSSWrapper

Return Values

Quest.LogReader.SqlServer.Wrappers.CommandWrapper

Examples

EXAMPLE 1

$lr = New-SQLSqlReader -Online . Northwind Windows
Get-QLRSqlCommand $lr

These commands read all DML/DDL changes in the Northwind database on the local server.

EXAMPLE 2

$lr = New-SQLSqlReader -Online . Northwind Windows
Get-QLRSqlCommand $lr -After 01.01.2007

These commands read all DML/DDL changes that were made after 01.01.2007 in the Northwind database on the local server.