Migration of SQL database for Composer

[R_Mesa]

Has anyone had any experience migrating Horizon 7 to SQL 2016 from 2012? Any concerns I should be aware of?

Thanks

Robert

[mchadwick19 · Accepted solution]

I have done it once before and didn't run into issues following this doc: VMware Knowledge Base

It's pretty straight forward and the composer service either does or does not start and it's usually the SQL login for the new server.

Just make sure you have the correct SQL native client driver for the DSN and you have a good backup of the database.