---
name: "DBIx::Class::Schema::Loader::DBI::MSSQL"
section: "3pm"
platform: "linux"
package: "libdbix-class-schema-loader-perl"
version: "0.07053-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/DBIx::Class::Schema::Loader::DBI::MSSQL"
---

# DBIx::Class::Schema::Loader::DBI::MSSQL(3pm)

DBIx::Class::Schema::Loader::DBI MSSQL Implementation.

## NAME

DBIx::Class::Schema::Loader::DBI::MSSQL - DBIx::Class::Schema::Loader::DBI MSSQL Implementation.

## DESCRIPTION

Base driver for Microsoft SQL Server, used by DBIx::Class::Schema::Loader::DBI::Sybase::Microsoft\_SQL\_Server for support via DBD::Sybase and DBIx::Class::Schema::Loader::DBI::ODBC::Microsoft\_SQL\_Server for support via DBD::ODBC.

See DBIx::Class::Schema::Loader and DBIx::Class::Schema::Loader::Base for usage information.

## CASE SENSITIVITY

Most MSSQL databases use `"CI"` (case-insensitive) collation, for this reason generated column names are lower-cased as this makes them easier to work with in DBIx::Class.

We attempt to detect the database collation at startup for any database included in db\_schema, and set the column lowercasing behavior accordingly, as lower-cased column names do not work on case-sensitive databases.

To manually control case-sensitive mode, put:

```
    preserve_case => 1|0
```

in your Loader options.

See preserve\_case.

**NOTE:** this option used to be called `"case_sensitive_collation"`, but has been renamed to a more generic option.

## SEE ALSO

DBIx::Class::Schema::Loader::DBI::Sybase::Microsoft\_SQL\_Server, DBIx::Class::Schema::Loader::DBI::ODBC::Microsoft\_SQL\_Server, DBIx::Class::Schema::Loader, DBIx::Class::Schema::Loader::Base, DBIx::Class::Schema::Loader::DBI

## AUTHORS

See "AUTHORS" in DBIx::Class::Schema::Loader.

## LICENSE

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