< Back

Show-DaterpillarMigrationHistory

Mon Jan 13, 2020 8:57 am

NAME Show-DaterpillarMigrationHistory



SYNOPSIS

Prints the details and status information about all the migrations.





SYNTAX

Show-DaterpillarMigrationHistory [-ConnectionType] {SQL | TSQL | MySQL | SQLite} [[-Host] <string>] [[-User]

<string>] [[-Password] <string>] [[-Database] <string>] [[-MigrationsDirectory] <string>] [-ConnectionString

<string>] [-FlywayFilePath <string>] [-InpuObject <string>] [-PassThru <SwitchParameter>] [-Timeout <int>]

[<CommonParameters>]





DESCRIPTION

This cmdlet prints the details and status information about all the migrations.





PARAMETERS

-PassThru <SwitchParameter>





Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-ConnectionType <Language>

The SQL language of the script.



Possible values: SQL, TSQL, MySQL, SQLite



Required? true

Position? 1

Default value SQL

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-lang <Language>

The SQL language of the script.



Possible values: SQL, TSQL, MySQL, SQLite



This is an alias of the ConnectionType parameter.



Required? true

Position? 1

Default value SQL

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-type <Language>

The SQL language of the script.



Possible values: SQL, TSQL, MySQL, SQLite



This is an alias of the ConnectionType parameter.



Required? true

Position? 1

Default value SQL

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-connection-type <Language>

The SQL language of the script.



Possible values: SQL, TSQL, MySQL, SQLite



This is an alias of the ConnectionType parameter.



Required? true

Position? 1

Default value SQL

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-MigrationsDirectory <string>

The absolute-path of the directory that host the migration scripts.



Required? false

Position? 6

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-path <string>

The absolute-path of the directory that host the migration scripts.



This is an alias of the MigrationsDirectory parameter.



Required? false

Position? 6

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-fullname <string>

The absolute-path of the directory that host the migration scripts.



This is an alias of the MigrationsDirectory parameter.



Required? false

Position? 6

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-sql <string>

The absolute-path of the directory that host the migration scripts.



This is an alias of the MigrationsDirectory parameter.



Required? false

Position? 6

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-FlywayFilePath <string>

The absolute-path of the flyway executable file.



Required? false

Position? named

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-flyway <string>

The absolute-path of the flyway executable file.



This is an alias of the FlywayFilePath parameter.



Required? false

Position? named

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-Timeout <int>

The operation timeout interval in seconds. Defaults to 5 minutes.



Required? false

Position? named

Default value 0

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-InpuObject <string>

The absolute-path of the directory that host the migration scripts.



Required? false

Position? named

Default value

Accept pipeline input? true (ByValue)

Accept wildcard characters? false



-Host <string>

The server address.



Required? false

Position? 2

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-h <string>

The server address.



This is an alias of the Host parameter.



Required? false

Position? 2

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-User <string>

The authorized user.



Required? false

Position? 3

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-u <string>

The authorized user.



This is an alias of the User parameter.



Required? false

Position? 3

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-Password <string>

The database password.



Required? false

Position? 4

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-p <string>

The database password.



This is an alias of the Password parameter.



Required? false

Position? 4

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-Database <string>

The database name.



Required? false

Position? 5

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-d <string>

The database name.



This is an alias of the Database parameter.



Required? false

Position? 5

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-ConnectionString <string>

The database connection-string. Must be formatted as <key>=<value>



Required? false

Position? named

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-c <string>

The database connection-string. Must be formatted as <key>=<value>



This is an alias of the ConnectionString parameter.



Required? false

Position? named

Default value

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-connstr <string>

The database connection-string. Must be formatted as <key>=<value>



This is an alias of the ConnectionString parameter.



Required? false

Position? named

Default value

Accept pipeline input? true (ByPropertyName)

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

Acklann.Daterpillar.Language

The SQL language of the script.



System.String

The absolute-path of the directory that host the migration scripts.



System.String

The absolute-path of the flyway executable file.



System.Int32

The operation timeout interval in seconds. Defaults to 5 minutes.



System.String

The absolute-path of the directory that host the migration scripts.



System.String

The server address.



System.String

The authorized user.



System.String

The database password.



System.String

The database name.



System.String

The database connection-string. Must be formatted as <key>=<value>





OUTPUTS





RELATED LINKS

https://github.com/Ackara/Daterpillar

https://flywaydb.org/documentation/commandline/info