< Back

New-DaterpillarMigrationScript

Mon Jan 13, 2020 8:55 am

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