How to change schema of MS SQL table providing backwards compatibility?

Question

SQL

There is a database on MS SQL used in production.
It was designed many years ago and some architectural solutions showed their failure over time.
There is a desire to make changes to the schemas of some tables (change the types of some fields). But, since the database is used by a huge number of modules and there is no way to rewrite them all at once, a simple ALTER will immediately break everything here.
Is it possible to somehow change the scheme and temporarily ensure backward compatibility while rewriting modules?
Thoughts popped up in my mind like scripts that on the fly convert the types of some fields to the old format for individual modules. I don't really see the best way to do this. Maybe there is some standard mechanism?

Answer 1

Have you considered using views ?