Install Visual Studio with the SQL Server Data Tools workload
Open Visual Studio
Create a new SQL Server Database Project
Add your database schema objects to the project
Build the project to generate the DACPAC
Install the SSDT-PM package or extension if required by your environment
Configure the project properties for package and deployment settings
Add post-deployment and pre-deployment scripts if needed
Validate the project for build errors
Publish the DACPAC to the target SQL Server instance
Verify the deployed database objects and permissions
