< Back
New-DaterpillarMigrationScript
Post
NAME New-DaterpillarMigrationScript
SYNOPSIS
Generates a new migration script from the two specified '.schema.xml' files.
SYNTAX
New-DaterpillarMigrationScript [-Language] {SQL | TSQL | MySQL | SQLite} [[-Destination] <string>]
[-OldSchemaFilePath] <string> [-NewSchemaFilePath] <string> [-Descripiton <string>] [-OmitDropStatements
<SwitchParameter>] [<CommonParameters>]
New-DaterpillarMigrationScript [-Language] {SQL | TSQL | MySQL | SQLite} [[-Destination] <string>]
[-OldSchemaFilePath] <string> [[-NewSchemaFilePath] <string>] [-Descripiton <string>] [-InputObject <string>]
[-OmitDropStatements <SwitchParameter>] [<CommonParameters>]
DESCRIPTION
This cmdlet creates a new migration script from two '.schema.xml' files.
PARAMETERS
-OldSchemaFilePath <string>
The absolute-path of old/production '.schema.xml' file.
Required? true
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-o <string>
The absolute-path of old/production '.schema.xml' file.
This is an alias of the OldSchemaFilePath parameter.
Required? true
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-old <string>
The absolute-path of old/production '.schema.xml' file.
This is an alias of the OldSchemaFilePath parameter.
Required? true
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-snapshot <string>
The absolute-path of old/production '.schema.xml' file.
This is an alias of the OldSchemaFilePath parameter.
Required? true
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-NewSchemaFilePath <string>
The absolute-path of new/current '.schema.xml' file.
Required? true
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-n <string>
The absolute-path of new/current '.schema.xml' file.
This is an alias of the NewSchemaFilePath parameter.
Required? true
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-new <string>
The absolute-path of new/current '.schema.xml' file.
This is an alias of the NewSchemaFilePath parameter.
Required? true
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-path <string>
The absolute-path of new/current '.schema.xml' file.
This is an alias of the NewSchemaFilePath parameter.
Required? true
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-fullname <string>
The absolute-path of new/current '.schema.xml' file.
This is an alias of the NewSchemaFilePath parameter.
Required? true
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-Destination <string>
The absolute-path of the new migration script.
Required? false
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-d <string>
The absolute-path of the new migration script.
This is an alias of the Destination parameter.
Required? false
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-dest <string>
The absolute-path of the new migration script.
This is an alias of the Destination parameter.
Required? false
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Language <Language>
The dialect of the sql script.
Possible values: SQL, TSQL, MySQL, SQLite
Required? true
Position? 1
Default value SQL
Accept pipeline input? false
Accept wildcard characters? false
-l <Language>
The dialect of the sql script.
Possible values: SQL, TSQL, MySQL, SQLite
This is an alias of the Language parameter.
Required? true
Position? 1
Default value SQL
Accept pipeline input? false
Accept wildcard characters? false
-lang <Language>
The dialect of the sql script.
Possible values: SQL, TSQL, MySQL, SQLite
This is an alias of the Language parameter.
Required? true
Position? 1
Default value SQL
Accept pipeline input? false
Accept wildcard characters? false
-OmitDropStatements <SwitchParameter>
Exclude all drop statements, when present.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-no-drop <SwitchParameter>
Exclude all drop statements, when present.
This is an alias of the OmitDropStatements parameter.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Descripiton <string>
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-desc <string>
This is an alias of the Descripiton parameter.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-InputObject <string>
Required? false
Position? named
Default value
Accept pipeline input? true (ByValue)
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
System.String
The absolute-path of new/current '.schema.xml' file.
System.String
OUTPUTS
System.Management.Automation.PSObject
RELATED LINKS
https://github.com/Ackara/Daterpillar
SYNOPSIS
Generates a new migration script from the two specified '.schema.xml' files.
SYNTAX
New-DaterpillarMigrationScript [-Language] {SQL | TSQL | MySQL | SQLite} [[-Destination] <string>]
[-OldSchemaFilePath] <string> [-NewSchemaFilePath] <string> [-Descripiton <string>] [-OmitDropStatements
<SwitchParameter>] [<CommonParameters>]
New-DaterpillarMigrationScript [-Language] {SQL | TSQL | MySQL | SQLite} [[-Destination] <string>]
[-OldSchemaFilePath] <string> [[-NewSchemaFilePath] <string>] [-Descripiton <string>] [-InputObject <string>]
[-OmitDropStatements <SwitchParameter>] [<CommonParameters>]
DESCRIPTION
This cmdlet creates a new migration script from two '.schema.xml' files.
PARAMETERS
-OldSchemaFilePath <string>
The absolute-path of old/production '.schema.xml' file.
Required? true
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-o <string>
The absolute-path of old/production '.schema.xml' file.
This is an alias of the OldSchemaFilePath parameter.
Required? true
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-old <string>
The absolute-path of old/production '.schema.xml' file.
This is an alias of the OldSchemaFilePath parameter.
Required? true
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-snapshot <string>
The absolute-path of old/production '.schema.xml' file.
This is an alias of the OldSchemaFilePath parameter.
Required? true
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-NewSchemaFilePath <string>
The absolute-path of new/current '.schema.xml' file.
Required? true
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-n <string>
The absolute-path of new/current '.schema.xml' file.
This is an alias of the NewSchemaFilePath parameter.
Required? true
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-new <string>
The absolute-path of new/current '.schema.xml' file.
This is an alias of the NewSchemaFilePath parameter.
Required? true
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-path <string>
The absolute-path of new/current '.schema.xml' file.
This is an alias of the NewSchemaFilePath parameter.
Required? true
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-fullname <string>
The absolute-path of new/current '.schema.xml' file.
This is an alias of the NewSchemaFilePath parameter.
Required? true
Position? 4
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-Destination <string>
The absolute-path of the new migration script.
Required? false
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-d <string>
The absolute-path of the new migration script.
This is an alias of the Destination parameter.
Required? false
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-dest <string>
The absolute-path of the new migration script.
This is an alias of the Destination parameter.
Required? false
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Language <Language>
The dialect of the sql script.
Possible values: SQL, TSQL, MySQL, SQLite
Required? true
Position? 1
Default value SQL
Accept pipeline input? false
Accept wildcard characters? false
-l <Language>
The dialect of the sql script.
Possible values: SQL, TSQL, MySQL, SQLite
This is an alias of the Language parameter.
Required? true
Position? 1
Default value SQL
Accept pipeline input? false
Accept wildcard characters? false
-lang <Language>
The dialect of the sql script.
Possible values: SQL, TSQL, MySQL, SQLite
This is an alias of the Language parameter.
Required? true
Position? 1
Default value SQL
Accept pipeline input? false
Accept wildcard characters? false
-OmitDropStatements <SwitchParameter>
Exclude all drop statements, when present.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-no-drop <SwitchParameter>
Exclude all drop statements, when present.
This is an alias of the OmitDropStatements parameter.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Descripiton <string>
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-desc <string>
This is an alias of the Descripiton parameter.
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-InputObject <string>
Required? false
Position? named
Default value
Accept pipeline input? true (ByValue)
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
System.String
The absolute-path of new/current '.schema.xml' file.
System.String
OUTPUTS
System.Management.Automation.PSObject
RELATED LINKS
https://github.com/Ackara/Daterpillar