< Back
Update-DaterpillarSchema
Post
NAME Update-DaterpillarSchema
SYNOPSIS
Migrates a schema to the latest version.
SYNTAX
Update-DaterpillarSchema [-ConnectionType] {SQL | TSQL | MySQL | SQLite} [[-Host] <string>] [[-User] <string>]
[[-Password] <string>] [[-Database] <string>] [[-MigrationsDirectory] <string>] [-ConnectionString <string>]
[-FlywayFilePath <string>] [-InpuObject <string>] [-NewSchema <FileInfo>] [-OldSchema <FileInfo>] [-Timeout <int>]
[<CommonParameters>]
DESCRIPTION
This cmdlet will execute all pending migration scripts in the specified directory.
PARAMETERS
-OldSchema <FileInfo>
The current/production '.schema.xml' file. Typically the 'snapshot.schema.xml' file.
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-NewSchema <FileInfo>
The new '.schema.xml' file. Typically the '[assembly].schema.xml' file.
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
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
System.IO.FileInfo
The current/production '.schema.xml' file. Typically the 'snapshot.schema.xml' file.
System.IO.FileInfo
The new '.schema.xml' file. Typically the '[assembly].schema.xml' file.
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/migrate
SYNOPSIS
Migrates a schema to the latest version.
SYNTAX
Update-DaterpillarSchema [-ConnectionType] {SQL | TSQL | MySQL | SQLite} [[-Host] <string>] [[-User] <string>]
[[-Password] <string>] [[-Database] <string>] [[-MigrationsDirectory] <string>] [-ConnectionString <string>]
[-FlywayFilePath <string>] [-InpuObject <string>] [-NewSchema <FileInfo>] [-OldSchema <FileInfo>] [-Timeout <int>]
[<CommonParameters>]
DESCRIPTION
This cmdlet will execute all pending migration scripts in the specified directory.
PARAMETERS
-OldSchema <FileInfo>
The current/production '.schema.xml' file. Typically the 'snapshot.schema.xml' file.
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? false
-NewSchema <FileInfo>
The new '.schema.xml' file. Typically the '[assembly].schema.xml' file.
Required? false
Position? named
Default value
Accept pipeline input? true (ByPropertyName)
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
System.IO.FileInfo
The current/production '.schema.xml' file. Typically the 'snapshot.schema.xml' file.
System.IO.FileInfo
The new '.schema.xml' file. Typically the '[assembly].schema.xml' file.
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/migrate