What are you using to compare and synchronize database schemas? DBAs need to be confident that deployment scripts accurately reflect the changes that were intended to come from development. The need for accurate scripts becomes even more urgent in companies moving toward Continuous Deployment.
We saw an ideal way to build those functions into Toad for Oracle Xpert Edition with Compare Schema & Sync. In fact, we’ve added a new feature, Compare Multiple Schemas & Sync, especially useful for DBAs who have to maintain the accuracy of multiple schemas between two databases.
- Open Compare Schema from the Toad menu.
- Select Source Schema by name (e.g., “prod”), then one or more target schemas by name (e.g., “test”).
- Optionally select a Toad snapshot file, which represents a schema in a certain state at a given point in time.
- Select the types of objects to compare and click Run.
Watch our John Pocknell demonstrate how to compare schemas in this Toad Xpert Edition video (3 minutes):
The results show the differences between the schemas, such as any objects present in one and absent from the other. Toad can also generate a synchronization script for applying the changes to the target database.
This is the final post in my 5-part video series designed to help you decide whether Toad for Oracle Xpert Edition is right for you. If the possibility of inaccurate schema deployments is keeping you up at night, have a look at Reason #5 in our updated technical brief, “Five Ways Toad Xpert Edition Can Help You Write Better Code,” for more details on comparing schemas.
And, if you want to compare and synchronize a few hundred schemas in your own databases, download a 30-day trial and take Toad Xpert Edition for a test drive.