I'm working on setting up unit tests to auto-run with our TeamCity builds. Some of our tests run against a unit test database that we have stored as mdf and ldf files that get attached to a SQL Server instance, and I've ran into an issue where the SQL Server version on the TeamCity server is too old to attach our mdf/ldf files.
Is it possible to update the SQL Server version from 2017 to 2019 on the TeamCity server? If so, is this something TeamCity handles or my team will need to do? I spoke with one of my IT teammates and we are unsure about upgrading it ourselves as we're wondering if it could mess something up with it being compatible with TeamCity or losing data in the TeamCity database, plus we don't have a Product Key for the upgrade (Standard installation).