Share via

Export-NAVApplicationObject

Module:
Microsoft.Dynamics.Nav.Ide Module

Export Business Central application objects from a database into a file.

Syntax

All (Default) 

Export-NAVApplicationObject
    [-DatabaseName] <String>
    [-Path] <String>
    [-DatabaseServer <String>]
    [-LogPath <String>]
    [-Filter <String>]
    [-Force]
    [-ExportTxtSkipUnlicensed]
    [-ExportToNewSyntax]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

DatabaseAuthentication 

Export-NAVApplicationObject
    [-DatabaseName] <String>
    [-Path] <String>
    -Username <String>
    -Password <String>
    [-DatabaseServer <String>]
    [-LogPath <String>]
    [-Filter <String>]
    [-Force]
    [-ExportTxtSkipUnlicensed]
    [-ExportToNewSyntax]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

Description

The Export-NAVApplicationObject function exports the objects from the specified database into the specified file. A filter can be specified to select the application objects to be exported.

Examples

EXAMPLE 1

Export-NAVApplicationObject MyApp MyAppSrc.txt

Exports all application objects from the MyApp database to MyAppSrc.txt.

EXAMPLE 2

Export-NAVApplicationObject MyAppSrc.txt -DatabaseName MyApp

Exports all application objects from the MyApp database to MyAppSrc.txt.

EXAMPLE 3

Export-NAVApplicationObject MyApp COD1-10.txt -Filter 'Type=Codeunit;Id=1..10'

Exports codeunits 1..10 from the MyApp database to COD1-10.txt

EXAMPLE 4

Export-NAVApplicationObject COD1-10.txt -DatabaseName MyApp -Filter 'Type=Codeunit;Id=1..10'

Exports codeunits 1..10 from the MyApp database to COD1-10.txt

EXAMPLE 5

Export-NAVApplicationObject COD1-10.txt -DatabaseName MyApp -Filter 'Type=Codeunit;Id=1..10' | Import-NAVApplicationObject -DatabaseName MyApp2

Copies codeunits 1..10 from the MyApp database to the MyApp2 database.

EXAMPLE 6

Export-NAVApplicationObject MyAppSrc.txt -DatabaseName MyApp | Split-NAVApplicationObject -Destination MyAppSrc

Exports all application objects from the MyApp database and splits into single-object files in the MyAppSrc folder.

Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Parameter properties

Type:SwitchParameter
Default value:None
Supports wildcards:False
DontShow:False
Aliases:cf

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-DatabaseName

Specifies the name of the database from which you want to export.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:1
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-DatabaseServer

Specifies the name of the SQL server instance to which the database you want to import into is attached. The default value is the default instance on the local host (.).

Parameter properties

Type:String
Default value:.
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-ExportToNewSyntax

Export the application object to the syntax supported by the Txt2Al converter.

Parameter properties

Type:SwitchParameter
Default value:False
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-ExportTxtSkipUnlicensed

Allows the command to skip application objects that are excluded from license, when exporting as txt.

Parameter properties

Type:SwitchParameter
Default value:False
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Filter

Specifies the filter that selects the objects to export.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Force

Allows the command to create a file that overwrites an existing file.

Parameter properties

Type:SwitchParameter
Default value:False
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-LogPath

Specifies the log folder.

Parameter properties

Type:String
Default value:"$Env:TEMP\NavIde\$([GUID]::NewGuid().GUID)"
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Password

The password to use with the username parameter to authenticate to the database. If you do not specify a user name and password, then the command uses the credentials of the current Windows user to authenticate to the database.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

DatabaseAuthentication
Position:Named
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Path

Specifies the file to export to.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:2
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Username

The user name to use to authenticate to the database. The user name must exist in the database. If you do not specify a user name and password, then the command uses the credentials of the current Windows user to authenticate to the database.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

DatabaseAuthentication
Position:Named
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Parameter properties

Type:SwitchParameter
Default value:None
Supports wildcards:False
DontShow:False
Aliases:wi

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

CommonParameters

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

Inputs

None

You cannot pipe input to this function.

Outputs

System.IO.FileInfo

An object representing the exported file.