MSSQL - NTEXT type being snapshot with MSSQL driver default size parameter.

Description

The incorrect size is being snapshot for the MSSQL NTEXT data type.

STEPS TO REPRODUCE THE ISSUE
1. Create or drop all tables in a test MSSQL database named "datical."
2. In MSSQL Mgmt Studio, execute the script MSSQL_Incorrect_Types_Snapshotted.sql to populate the 'datical' table with schemas to snapshot.
3. In Datical DB, configure a deployment plan to connect to the test MSSQL server.
4. Connect to the database.
5. Take a snapshot and note the datatypes returned for each changeset.

ACTUAL RESULTS
The NTEXT datatype is being snapshotted as NTEXT(1073741823).

EXPECTED RESULTS
The NTEXT datatype should be snapshot as NTEXT, and not have any size parameter associated with it.

Nathan has a fix for this at commit 9e9299.

This ticket to to track when it gets released.

Environment

Windows 7 with Microsoft SQL Server Express 11.0.2100

Status

Reporter

Kevin Chappell

Fix versions

Affects versions

Priority

Critical
Configure