Answers

Question and Answer:

  Home  Ab Initio

⟩ Describe how you would ensure that database object definitions (Tables, Indices, Constraints, Triggers, Users, Logins, Connection Options, and Server Options etc) are consistent and repeatable between multiple database instances (i.e. a test and production copy of a database)?

Take an entire database backup and restore it in different instance.

Take a statistics of all valid and invalid objects and match.

Periodically refresh

 170 views

More Questions for you: