< Back
Invoke-DevartDataImport
Post
NAME Invoke-DevartDataImport
SYNOPSIS
Imports data from the files into a database.
SYNTAX
Invoke-DevartDataImport -TemplateFile <string> [-Connection <object>] [-Create <SwitchParameter>] [-InputFile
<string>] [-InputTable <string>] [-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
-Create <SwitchParameter>
If specified, new table to import the data to will be created.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-InputFile <string>
Specifies file with the data that you want to import. Option is inaccessible for ODBC format.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-InputTable <string>
Specifies table or view to import the data from (for Access and ODBC formats).
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Table <string>
Specifies target table (the one where you want to insert the imported data).
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-TemplateFile <string>
Specifies template file.
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-DevartDataImport -Connection $connection -TemplateFile "C:\\Temp\\template.dit"
RELATED LINKS
Online help:
https://docs.devart.com/devops-automati ... mport.html
SYNOPSIS
Imports data from the files into a database.
SYNTAX
Invoke-DevartDataImport -TemplateFile <string> [-Connection <object>] [-Create <SwitchParameter>] [-InputFile
<string>] [-InputTable <string>] [-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
-Create <SwitchParameter>
If specified, new table to import the data to will be created.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-InputFile <string>
Specifies file with the data that you want to import. Option is inaccessible for ODBC format.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-InputTable <string>
Specifies table or view to import the data from (for Access and ODBC formats).
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Table <string>
Specifies target table (the one where you want to insert the imported data).
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-TemplateFile <string>
Specifies template file.
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-DevartDataImport -Connection $connection -TemplateFile "C:\\Temp\\template.dit"
RELATED LINKS
Online help:
https://docs.devart.com/devops-automati ... mport.html