Question

Disadvantage of State based Database development is

Answer 1

The main feature of state based database development is to gain reliable, repeatable database deployments as part of database development operations. Every database build and change, however trivial, should therefore start from version control, ideally alongside the application code.

There are three disadvantages of state-based  database development:

1. Developers dont have alot of control over deployment script generation .

2. There is poor support for user data migration .

3. Additional review of generated script required, developers have to check generated script before deployment.