Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature] MS SQL Inbox and Outbox DDL NText is deprecated #2476

Closed
holytshirt opened this issue Jan 13, 2023 · 1 comment · Fixed by #2560
Closed

[Feature] MS SQL Inbox and Outbox DDL NText is deprecated #2476

holytshirt opened this issue Jan 13, 2023 · 1 comment · Fixed by #2560

Comments

@holytshirt
Copy link
Member

https://learn.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql

The ntext, text, and image data types will be removed in a future version of SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.

The DDL we provided for Inbox and Outbox uses NText to store body and header

Inbox
https://github.com/BrighterCommand/Brighter/blob/master/src/Paramore.Brighter.Inbox.MsSql/DDL%20Scripts/MSSQL/Inbox.sql
https://github.com/BrighterCommand/Brighter/blob/master/src/Paramore.Brighter.Inbox.MsSql/SqlInboxBuilder.cs#L38

OutBox
https://github.com/BrighterCommand/Brighter/blob/master/src/Paramore.Brighter.Outbox.MsSql/DDL_SCRIPTS/MSSQL/Outbox.sql
https://github.com/BrighterCommand/Brighter/blob/master/src/Paramore.Brighter.Outbox.MsSql/SqlOutboxBuilder.cs

@iancooper
Copy link
Member

@holytshirt Can pick up as part of work to support a binary outbox.

@iancooper iancooper changed the title MS SQL Inbox and Outbox DDL NText is deprecated [Feature] MS SQL Inbox and Outbox DDL NText is deprecated Apr 17, 2023
@iancooper iancooper linked a pull request Apr 17, 2023 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants