Using Database Compare with PowerShell in Toad DevOps Toolkit

Hello, folks. My name is Robert Pound, and I'm a product technologist for Quest. In this video we'll be discussing Toad DevOps Toolkit Database Compare. Toad DevOps Toolkit is a Windows application that allows you to reliably execute Oracle database functions within a continuous integration platform such as Bamboo or Jenkins. Toad DevOps Toolkit supports access through a number of languages. But the focus of this video will be using PowerShell. It is assumed for this video that you have knowledge of PowerShell continuous integration platforms like Bamboo and Jenkins and an understanding of the Toad features being discussed. There are several components to help you along your DevOps journey. The focus of this video will be the differences in database using the Database Compare feature. It is helpful, but not necessary, to review the Database Compare feature in Toad for Oracle as a reference point getting started. It may also be helpful to review the Examples folder by navigating to your Toad DevOps Installation, Examples, PowerShell, and PowerShell Scripts to check out all the different PowerShell examples available to you. Looking at the Database Compare feature, it contains all the examples possible for the database compare. It is available as a guide when creating your PowerShell scripts. Now let's switch over to a simple example so we can understand the basics of the Compare Database feature. Before I get started, I'm using PowerShell 5.0, and that is because that was the PowerShell used to develop the examples. However, it's not necessary when working with the Toad DevOps Toolkit. And also, for simplicity's sake, I am not using standard code practices. At the top I have my database connection information schemas, as well as the connection strings themselves. And the first thing we're going to do is create a new com object Toad.ToadAutoObject, which starts the Toad DevOps Toolkit process and creates a variable. Next, we connect to the Source and Target databases with the information above. And next, we will set the parameters for the database compare. For this example, we're going to include all objects. And for the Database Compare feature itself, we're going to designate the Source database with the Source information from above. And we're also going to add a single Target database and also provide the connection information for the Target database. And finally, we're going to designate output files for this object, so the difference details, the summary in HTML, schema snapshot in JSON, and a sync script, an SQL script, obviously. And finally, once we designate all those file parameters, and we have our parameters set, we go ahead execute the Database Compare. And once the comparison is completed, we go ahead and Quit to stop the process. Now let's take a look at the C Temp folder to see the different output files from the database compare. We've output several different files, and if we take a look quickly at one of them just as a reference, in this case, we can see that we're comparing a database from two separate connections. So that was an overview of how to compare databases in the Toad DevOps Toolkit using PowerShell. For more information on this topic, you can go to your Start menu, and all programs navigate to Quest Software and Toad DevOps Toolkit, and select the Help file to get more information on the topic. You can also check out the community-driven innovation going on at www.ToadWorld.com. For more information on this product, go to www.Quest.com/products/Toad-DevOps-Toolkit. Thank you, and have an excellent day.