Database deployments are often more complicated than deploying a web application or service as production databases are typically clusters or high-availability groups. They are often comprised of more than one node hidden behind a VIP (virtual IP address).
Database deployment tooling doesn’t need to run an executable directly on the database server. Instead, it needs to run somewhere that connects to the database over a specific port as specific user to run scripts:
- SQL Server:
The user account running the scripts needs permission to modify the database.
Help us continuously improve
Please let us know if you have any feedback about this page.
Last updated Sunday, January 1, 2023