Preparing to migrate RDM database from SQL 2008R2 (on-prem) to Azure SQL (paas)
Preparing to migrate RDM database from SQL 2008R2 (on-prem) to Azure SQL (paas)
I've started the process of testing this migration using Microsoft's Data Assistant and as part of the assessment it raised the following flag:
--
Table: dbo.UserAccount
This object can be migrated, but you may need to fix the issues described below.
Issue: Deprecated data types TEXT, IMAGE or NTEXT
Change category: Information issues
Object details: Object dbo.UserAccount.PersonalConnections uses deprecated data type TEXT, IMAGE or NTEXT which will be discontinued for future versions of SQL Server. For more details, please see: Line 13, Column 5.
Everything else looks clean for now, but I was curious if there were plans in the future versions of RDM to convert that column to varchar, nvarchar, or varbinary as per MS recommendation?
All Comments (4)
There shouldn't be any IMAGE, TEXT or NTEXT in the RDM database at least not since a few versions (older versions yes). A few years ago the upgrade script converted them all to NVARCHAR(MAX) or VARCHAR(MAX).
Can you please send us your database schema for analysis, we will double check vs. a know good schema and let you know where/what is off. We can then issue a few update scripts to "fix" your schema.
File > Data Sources > Upgrade (tab) > Email Schema to Support
Please add "Attn: Stefane" to the subject line, the schema dump will get to me faster that way.
Best regards,
Stéfane Lavergne
Thank you for the schema.
You only have a single column that wasn't converted.
Best regards,
Stéfane Lavergne
You might need to recreate the view to make the column type change be applied to the view. I will send you the view script via private message.
Stéfane Lavergne
Thank you. DMA is no longer complaining about the column and I've updated the view as well. We'll give it some testing but the original ticket can be closed if open.