✅ Purpose of generating SQL Script in EF Core
Hello guys, was just wondering, what is the purpose of generating the SQL script in EF Core? Normally, we need to update the migration then we would be able to generate a sql script. So what's the point of generating the script? Is it because normally, all test/migrations will first be done in a testing/development environment and so generating the script will show us whether our sql script matches the scheme we wanted to have or it's useful because a database administrator can give his feedbacks/opinions before proceeding to production environment?
4 Replies
If we would need to make changes manually to the database, then we would shift to the database first approach ?
security and control. the app servers have no reason to modify the database
also if you have multiple servers starting up and trying to apply migrations it will probably not work well
normally you have multiple db users, where they are limited to only being able to select/insert/update/delete as needed
there is also the option of making an bundle to apply migrations, not only a raw sql script
Principle of least privilege
In information security, computer science, and other fields, the principle of least privilege (PoLP), also known as the principle of minimal privilege (PoMP) or the principle of least authority (PoLA), requires that in a particular abstraction layer of a computing environment, every module (such as a process, a user, or a program, depending on t...
yep I see, thanks !