Hello data people. My name is Robert Pound, and I am a Product Technologist at Quest. This video will demonstrate how to use file sync feature, as well as the comparison tool for versioning in Toad Edge.
To sync to a file system, we first have to choose the proper connection, and then the database. And once we have the database selected, we can right click on it, choose file system synchronization, and map database to file system. We will choose an empty folder. And depending on how you're sharing this out, you may choose a network drive. But for the purposes of this demo, I'm going to choose a folder on the local drive, and choose the empty prod 19 folder, and click OK.
And now the objects associated with this database are synced to this file folder. And if we look in that file folder, we can see there's been several sub folders created. And if we open one of them up, we can see there is a JSON file for each one of the objects in the database.
From here we can use the version controlled system of our choice. In this case, I'm using Git. So I will simply copy these commands in. And I'm connecting to a repository I've already created in GitHub.
So just real briefly, when I refresh this, we'll see that the repo has been updated with all the objects from the database.
So now that we have versioned the system, let's go ahead and make a change. So I'll just choose one at random here. Let's go ahead and update the City table. So if I decided that 100 wasn't enough. Let's go ahead and modify this to 120. Click OK. Now if we do a comparison of the database, or the object itself, we're going to get an update. And you can see that there's an icon here in the Object Explorer itself showing that there is an update. So if I right click File Synchronization and choose Compare, it's going to compare this table with the file sync and let me know that there has been a change made. In this case, updating 100 to 120.
And we can use the change script and modify it in either direction. Either revert back to the original version, or update the version controlled system. And then use Git to update the changes. Also if another user wanted to also look at the repository, they could simply create an empty database and then sync that database to the shared directory. And from there you'd be able to update your database based on the JSON objects in the file share.
I hope this video was helpful. For more information on this product preview, search for Toad Edge on www.toadworld.com. For the upcoming full release of the product coming later this year, check out www.quest.com. Thank you, and have a great day.
05:07