A bit of an oddball question here. I think the answer is a simple 'yes' but I could do with some confirmation.
I am looking migrate some SQL 2012 databases to SQL 2016. Our software support contractor have stated they would like the data databases to remain in SQL 2012 compatibility verson. They do not manage the servers or SQL engine, just the database structure and programability. I like the feature of multiple tempDB files having improved management in SQL 2016 (not having to manually set trace flags by following notes I don't fully understand).
As the tempdb files are at the engine level, would this impact a data database set to an earlier compatibility level?
Thanks in advance