Answer Detail: RE: Describe how you would ensure that database object...

GeekInterview.com > Interview Questions > Data Warehousing > Abinitio

Print |

Question: 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).

June 06, 2006 06:27:26	#1
kalyan	Member Since: Visitor Total Comments: N/A
RE: Describe how you would ensure that database object...
Take an entire database backup and restore it in different instance. Take a statistics of all valid and invalid objects and match. Periodically refresh

Back To Question