Hey Guys, we are finally on the phase of upgrading our vCloud Director from 9.1 (w/ external MSSQL 2014) to 9.7.
First, we are looking into upgrading our database to MSSQL 2017 but when I ran the Microsoft’s Data Migration Assistant (DMA), I got some issues namely:
**4 Unqualified Join(s) Detected**
**1 Deprecated Datatype**
*Object dbo.audit_event.details uses deprecated data type TEXT, IMAGE or NTEXT which will be discontinued for future versions of SQL Server.*
Some have a recommended solution from DMA and some don’t so now I’m not sure if I can just ignore these and proceed with the database upgrade. Is it easier just to move completely off MSSQL to Postgres while at 9.1? We are also looking into moving to the appliance version once we are on 9.7.
View Reddit by sysadasks – View Source