NAME

DBIO::MSSQL - Microsoft SQL Server-specific schema management for DBIO

VERSION

version 0.900000

SYNOPSIS

package MySchema;
use DBIO Schema => -ms;

# ... later
my $schema = MySchema->connect($dsn, $user, $pass);
# Storage is automatically set to DBIO::MSSQL::Storage

DESCRIPTION

This class is a thin DBIO subclass that automatically sets the storage class to DBIO::MSSQL::Storage when a connection is established. Load it into your schema instead of the base DBIO class when connecting to Microsoft SQL Server databases.

The -ms shortcut (see DBIO::Shortcut::ms) is the recommended way to enable the MSSQL driver: on a schema class use DBIO 'Schema', -ms; pins the storage to DBIO::MSSQL::Storage, and on a result class use DBIO 'Core', -ms; loads the DBIO::MSSQL::Result component.

For connections via DBD::Sybase (including FreeTDS), see DBIO::MSSQL::Storage::Sybase.

METHODS

connection

$schema->connection($dsn, $user, $pass, \%attrs);

Sets the storage type to DBIO::MSSQL::Storage before delegating to the parent connection method.

SEE ALSO

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.