How to keep test data updated with Toad for SAP Solutions

Hello, their internet. My name is Robert Pound, and I am a product technologist for Quest. This video will cover how to keep your test data up to date in SAP. For this demo, I've already established a connection to an ASE database. So to keep your test data up to date, you'll need to run a comparison. We can do that from the tools menu. But I like to use the ribbon bar. So I'll go ahead and click Data compare. And if we had multiple connections, we could choose the different connections at this time. But since I only have one connected, I'll just choose our source and our target databases. As you can see, we have an issue with the comparison key for this table. And it's actually not one of the objects that I'm interested in comparing. So I'm going to go ahead and clear all. And what we're going to do is just match up individual objects. So for instance, item. I'm going to choose on the target item test. And we can see there's an issue with the column. So in creating this table, I made it all varchar. And it's not working with this binary. So I'm going to go ahead and exclude this from the comparison. And let's add one more warehouse. And we'll go ahead and click Next. And I could change the comparison options. But I'm going to leave them default. And as we can see, the warehouse is up to date. But the item table has some differences. So let's go ahead and click Finish and look at them. So if we wanted to see the different objects, we can select them here in this field. But I'm going to go ahead and focus on item since it's the one that has the differences, so we can see everything. We can see what's different, what's in the source only, what has different records. We can see in this case the name is different here and the price is different in this entry. We can see what's in the target only. So that's the differences themselves. But if we wanted to update this data for our test environment, we could choose the Synchronization Wizard. So we can choose the direction. In this case, I'm going to make the target look like the source. And this is where the script will be saved. And any sort of synchronization options, again, I'm going to leave default. And we can choose to run it immediately. I'm going to go ahead and open it in the editor. And you can see from here we have the different inserts, deletes, and updates. We can continue editing from here as we so choose. And that's taking you through the process of updating your test data. Hopefully this helped you understand a little bit more about [INAUDIBLE] AP and what it can do for you. For more information, you can check out the Help file. It has a wide range of information as well as tutorials to help get you started. You can also check out the community driven innovation going on at www.ToadWorld.com and clicking the blog tab. Quest provides award winning online support at www.support.quest.com, where you can find robust, knowledge based articles and assistance from our expert technical support engineers. For more information on this product, visit www.quest.com/products/TOAD-for-SAP-Solutions. Thank you, and have a tremendous day.