Invoke-DevartDataExport

Synopsis

Exports data from a database into files.

Description

Use the cmdlet to export data from one or several tables to the following file formats: HTML, Text, XLS, XLSX, MS Access, RTF, PDF, JSON, XML, CSV, ODBC, DBF, SQL.

Syntax

Invoke-DevartDataExport -TemplateFile <string> [-Connection <object>] [-OutputFile <string>] [-OutputTable <string>] [-Range <string>] [-SingleFile <SwitchParameter>] [-Table <string>] [<CommonParameters>]

Parameters

-Connection <object>

The DevartDatabaseConnectionInfo or connection string.

Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false

-OutputFile <string>

Specifies destination file, or directory for multiple export. Option is inaccessible for ODBC format.

Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false

-OutputTable <string>

Specifies destination table name, this option is available for SQL, ODBC and Access formats.

Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false

-Range <string>

Specifies range of exported rows.

Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false

-SingleFile <SwitchParameter>

Specifies that all data has to be exported into single file, even if there are several source tables.

Required? false

Position? named

Default value? false

Accept pipeline input? false

Accept wildcard characters? false

-Table <string>

Specifies source table name, there can be some tables specified.

Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false

-TemplateFile <string>

Specifies a *.det data export template file containing data export settings.

Required? true

Position? named

default value

Accept pipeline input? false

Accept wildcard characters? false

<CommonParameters>

This cmdlet supports the following common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, InformationAction, InformationVariable, OutBuffer, PipelineVariable, and OutVariable. For more information, see About CommonParameters.

Outputs

System.Boolean (returns true on success and false otherwise)

Examples

---------- EXAMPLE 1 ----------
Invoke-DevartDataExport -Connection $connection -TemplateFile "C:\Temp\template.det"

See Switches used in the command line for information on additional command line options.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge DevOps Automation for SQL Server.
Request a demo

Request a demo

If you consider employing the DevOps Automation for your business, request a demo to see it in action.
Ready to start using dbForge DevOps Automation for SQL Server?
Download a free 30-day trial