How to automate database schema changes for the CI process during database deployment
ℹ️ The dbForge Schema Compare tool plays an important part in creating databases from state-based scripts and can be used both for state-based and migration scripts development approaches. In this video, we'll examine how dbForge Schema Compare can be used in the DevOps processes.
⚙️ Schema Compare is used in the development process each time developers make changes in the database schema on the SQL Server instance and these changes should be reflected in the script folder.
⚙️ To synchronize the database with the script folder, you should choose a New Schema Comparison In the wizard that will be opened, fill in all the necessary fields.
⚙️ All changes can be seen in a newly-opened document.
⚙️ Next, press F8, choose Update the scripts folder, and initiate the synchronization process.
⚙️ After this, the contents of the script folder will be synchronized with the changes that have just been made.
As we can see, dbForge Schema Compare plays a key role in different aspects of the DevOps process, including database development and the CI process during database deployment.
Check more useful information:
🔥 How dbForge Schema Compare is involved in the DevOps process:
https://www.devart.com/dbforge/sql/da...
🔥 DevOps Automation is a part of SQL Tools:
https://www.devart.com/dbforge/sql/da...
✅ Subscribe to our channel: / devartsoftware
#SchemaCompare #SQL #DevOps #SQLDatabase #dbForge #Devart
Watch video How to automate database schema changes for the CI process during database deployment online without registration, duration hours minute second in high quality. This video was added by user Devart 09 November 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,765 once and liked it 26 people.