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


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.


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, and set the column lowercasing behavior accordingly, as lower-cased column names do not work on case-sensitive databases.

If you are using FreeTDS with tds version set to 8.0 the collation detection may fail, and Loader will default to case-insensitive mode. tds version 7.0 will work fine.

If this happens set:

    case_sensitive_collation => 1

in your Loader options to override it.


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


See "AUTHOR" in DBIx::Class::Schema::Loader and "CONTRIBUTORS" in DBIx::Class::Schema::Loader.


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