Exports data from a database into the files.
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.
Invoke-DevartDataExport -TemplateFile <string> [-Connection <object>] [-OutputFile <string>] [-OutputTable <string>] [-Range <string>] [-SingleFile <SwitchParameter>] [-Table <string>] [<CommonParameters>]
-TemplateFile <string>
Specifies a *.det data import template file containing data export settings.
Required? true
Position? named
Accept pipeline input? false
Accept wildcard characters? false
-Connection <object>
The DevartDatabaseConnectionInfo or connection string.
Required? false
Position? named
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
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
Accept pipeline input? false
Accept wildcard characters? false
-Range <string>
Specifies range of exported rows.
Required? false
Position? named
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
Accept pipeline input? false
Accept wildcard characters? false
System.Boolean (returns true on success and false otherwise)
---------- EXAMPLE 1 ----------
Invoke-DevartDataExport -Connection $connection -TemplateFile "C:\Temp\template.det"