Invoke-DevartDataExport

NAME Invoke-DevartDataExport



SYNOPSIS

Exports data from a database into the files.





SYNTAX

Invoke-DevartDataExport -TemplateFile <string> [-Connection <object>] [-OutputFile <string>] [-OutputTable

<string>] [-Range <string>] [-SingleFile <SwitchParameter>] [-Table <string>] [<CommonParameters>]





DESCRIPTION





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 import 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 common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS

System.Boolean





---------- EXAMPLE 1 ----------



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





RELATED LINKS

Online help:

https://docs.devart.com/devops-automati ... xport.html