I am using the Project Server application which sits on top of a database. I have hundreds of edits to make to Project Server but It’s unrealistic to edit all of the Projects, one at a time. Instead of doing it one at a time, I was thinking of running an UPDATE sql script to write directly to the database.
Is this considered bad practice and would it break project server?
As soon as you do any writing on the DB by yourself or touch the schema you just lost your support from microsoft. They reserve the right to do any change in the db with each update.
Do not do it. Don't.
Use PSI or the REST API. Those are your friends.