< Back
Export-P1LegacyEnvironment
Post
NAME Export-P1LegacyEnvironment
SYNOPSIS
Export legacy PlannerOne environment to file.
SYNTAX
Export-P1LegacyEnvironment [-SQLServer] <String> [-Database] <String> [[-OutDir] <String>] [[-ForceDatatableName]
<String>] [[-Product] <String>] [-UseUIdAsName] [<CommonParameters>]
DESCRIPTION
Export an existing and initialized legacy environment stored in a database and save it to file system.
Each environments found for Production Scheduler and ResourcePlanner will be exported in its own file in -OutDir
directory.
PARAMETERS
-SQLServer <String>
The SQL Server host name and instance.
Required? true
Position? 1
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Database <String>
The SQL Server database name.
Required? true
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-OutDir <String>
The root directory path to use for export. .\\p1EnvExport by default.
Required? false
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ForceDatatableName <String>
Force datatable name to export. By default script will export sequentially dbo.EnvironmentProductionDao and
dbo.EnvironmentProjectDao.
Required? false
Position? 4
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Product <String>
Select product to export environment from.
Valid values are: Production, Projects, All.
Default value is All.
All option cannot be used with ForceDatatableName.
Required? false
Position? 5
Default value
Accept pipeline input? false
Accept wildcard characters? false
-UseUIdAsName [<SwitchParameter>]
Do not try to retrieve Planning name and Planning Group Container to create directories.
Use environment UId.
Use this option if environments names are not valid for directory names.
Required? false
Position? named
Default value False
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
RELATED LINKS
SYNOPSIS
Export legacy PlannerOne environment to file.
SYNTAX
Export-P1LegacyEnvironment [-SQLServer] <String> [-Database] <String> [[-OutDir] <String>] [[-ForceDatatableName]
<String>] [[-Product] <String>] [-UseUIdAsName] [<CommonParameters>]
DESCRIPTION
Export an existing and initialized legacy environment stored in a database and save it to file system.
Each environments found for Production Scheduler and ResourcePlanner will be exported in its own file in -OutDir
directory.
PARAMETERS
-SQLServer <String>
The SQL Server host name and instance.
Required? true
Position? 1
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Database <String>
The SQL Server database name.
Required? true
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-OutDir <String>
The root directory path to use for export. .\\p1EnvExport by default.
Required? false
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ForceDatatableName <String>
Force datatable name to export. By default script will export sequentially dbo.EnvironmentProductionDao and
dbo.EnvironmentProjectDao.
Required? false
Position? 4
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Product <String>
Select product to export environment from.
Valid values are: Production, Projects, All.
Default value is All.
All option cannot be used with ForceDatatableName.
Required? false
Position? 5
Default value
Accept pipeline input? false
Accept wildcard characters? false
-UseUIdAsName [<SwitchParameter>]
Do not try to retrieve Planning name and Planning Group Container to create directories.
Use environment UId.
Use this option if environments names are not valid for directory names.
Required? false
Position? named
Default value False
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
RELATED LINKS