/ 
DBIO-MSSQL-0.900000

Changes for version 0.900000 - 2026-06-23

  • First release. Microsoft SQL Server driver for DBIO.
  • Storage
    • SCOPE_IDENTITY() identity retrieval, MONEY column casting, ordered-subselect safety, SAVE TRANSACTION savepoints, deferred FK checks via sp_msforeachtable, and NEWID() GUID/random support
    • DBD::ODBC and DBD::MSSQL connection paths
    • DBD::Sybase/FreeTDS path with placeholder detection (NoBindVars rebless) and statement-cache workarounds
  • SQL generation
    • MSSQL SQLMaker with LIMIT/OFFSET via ROW_NUMBER() OVER() (with a (SELECT(1)) default order) and the TOP dialect for older servers
    • [ ] identifier quoting and SQLServer SQL::Translator type
  • Schema management
    • Native DDL generation, including CREATE VIEW for non-virtual views from view_definition
    • Native introspection via INFORMATION_SCHEMA and the sys.* catalog
    • Native diff of tables, columns, indexes, and foreign keys
    • test-deploy-and-compare install and upgrade via Deploy
  • Integration
    • DBIO::MSSQL schema component and the `use DBIO -ms` shortcut
    • Result component for MSSQL-specific indexes
    • base->native type Adapter
    • datetime parsing for the MSSQL and Sybase paths

Documentation

README.md

Modules

DBIO::MSSQL
Microsoft SQL Server-specific schema management for DBIO
DBIO::MSSQL::Adapter
MSSQL base->native type resolver
DBIO::MSSQL::DDL
Generate MSSQL DDL from DBIO Result classes
DBIO::MSSQL::Deploy
Deploy and upgrade MSSQL schemas via test-deploy-and-compare
DBIO::MSSQL::Diff
Compare two introspected MSSQL models
DBIO::MSSQL::Diff::Column
Diff operations for MSSQL columns
DBIO::MSSQL::Diff::ForeignKey
Diff operations for MSSQL foreign keys
DBIO::MSSQL::Diff::Index
Diff operations for MSSQL indexes
DBIO::MSSQL::Diff::Table
Diff operations for MSSQL tables
DBIO::MSSQL::Introspect
Introspect a Microsoft SQL Server database via information_schema
DBIO::MSSQL::Introspect::Columns
Introspect MSSQL columns
DBIO::MSSQL::Introspect::ForeignKeys
Introspect MSSQL foreign keys
DBIO::MSSQL::Introspect::Indexes
Introspect MSSQL indexes
DBIO::MSSQL::Introspect::Tables
Introspect MSSQL tables and views
DBIO::MSSQL::Result
MSSQL-specific Result component for DBIO
DBIO::MSSQL::SQLMaker
MSSQL-specific SQL generation for DBIO
DBIO::MSSQL::Storage
Base Class for Microsoft SQL Server support in DBIO
DBIO::MSSQL::Storage::DateTime::Format
DateTime parser for MSSQL datetime and smalldatetime columns
DBIO::MSSQL::Storage::Sybase
Support for Microsoft SQL Server via DBD::Sybase
DBIO::MSSQL::Storage::Sybase::DateTime::Format
DateTime parser for MSSQL via DBD::Sybase
DBIO::MSSQL::Storage::Sybase::NoBindVars
Support for Microsoft SQL Server via DBD::Sybase without placeholders
DBIO::Shortcut::ms
`use DBIO -ms` shortcut for the MSSQL driver

Other files