Invoke-DevartDataImport

Synopsis

Imports data from files into a database.

Description

Use the cmdlet to import data from the following file formats: Text, MS Excel, MS Access, XML, JSON, CSV, ODBC, DBF.

Syntax

Invoke-DevartDataImport [-Connection <object>] [-Create <SwitchParameter>] [-InputFile <string>] [-InputTable <string>] [-Table <string>] -TemplateFile <string> [<CommonParameters>]

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 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-DevartDataImport -Connection $connection -TemplateFile "C:\Temp\template.dit"

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