/ 
DBIO-MSSQL-0.900004
/ DBIO::MSSQL::Diff::Schema

NAME

DBIO::MSSQL::Diff::Schema - Diff operations for MSSQL schemas

VERSION

version 0.900004

DESCRIPTION

CREATE SCHEMA for a schema that the target needs and the live database lacks. A table named schema.table in the classes is made in that schema, and the schema must exist first; DBIO::MSSQL::Diff puts these operations before everything else. A schema that is no longer needed is not dropped (not decided; the tables in it are dropped, the schema stays).

Each statement is a batch of its own for the server: CREATE SCHEMA has to be the first statement of a batch, and the deploy runs the statements one at a time.

METHODS

diff

my @ops = DBIO::MSSQL::Diff::Schema->diff($source_model, $target_model);

The schemas the tables of the target model name (a model key schema.table, a view's too) that the source model has neither in its schemas section nor in the keys of its tables. dbo is always there. When the source model says its database ignores case (collation), schema names are compared ignoring case. Sorted by name.

as_sql

summary

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.