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
DBIO::MSSQL::Storage - MSSQL storage implementation
DBIO::MSSQL::SQLMaker - MSSQL SQL dialect
DBIO::MSSQL::Storage::Sybase - MSSQL via DBD::Sybase
DBIO - Base ORM class
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.