NAME

DBIO::Sybase::Deploy - Deploy and upgrade Sybase ASE schemas via test-deploy-and-compare

VERSION

version 0.900000

DESCRIPTION

DBIO::Sybase::Deploy orchestrates schema deployment and upgrades for Sybase ASE using the test-deploy-and-compare strategy.

For upgrades it:

1. Introspects the live database via INFORMATION_SCHEMA

2. Deploys the desired schema (from DBIO classes) to a temporary database

3. Introspects the temporary database the same way

4. Computes the diff between the two models using DBIO::Sybase::Diff

METHODS

install

$deploy->install;

Generates DDL via "install_ddl" in DBIO::Sybase::DDL and executes each statement against the connected database. Suitable for fresh installs.

NOTE: DBIO::Sybase::DDL does not yet exist. This method currently falls back to the SQL::Translator codepath via "deploy" in DBIO::Schema.

diff

my $diff = $deploy->diff;

Computes the difference between the live database and the desired state. Deploys the desired schema to a temporary database, introspects both, and returns a DBIO::Sybase::Diff object.

apply

$deploy->apply($diff);

Applies a DBIO::Sybase::Diff object by executing each statement from $diff->as_sql. No-op if the diff has no changes.

upgrade

my $diff = $deploy->upgrade;

Convenience: calls "diff" then "apply". Returns the diff object if changes were applied, or undef if the database was already up to date.

• DBIO::Sybase - schema component

• DBIO::Sybase::Introspect - reads live database state

• DBIO::Sybase::Diff - compares two introspected models

• DBIO::DuckDB::Deploy - reference implementation

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.