Toad Video: Compare & Sync Table Data Across Servers

thatjeffsmith Toad® Stuff (Retired) 6 Comments

Tell Others About This Story:

Sit back and relax as I take you through one of my favorite Toad features: Data Compare. In less than five minutes see how to:

  • Set your data comparison target and source
  • Configure which columns to compare
  • Use WHERE clause filters to limit data compared
  • View the results
  • Synchronize the data (optional)

Watch Jeff Compare 3 Tables Across 2 Databases in Less Than 5 Minutes

Tell Others About This Story:

Comments 6

    1. thatjeffsmith Post
  1. Jeff… currently, if the tables i am synching have an identity column… it DOES NOT bring across the ID.

    Do you know how to include the ID in the synch script generated by TOAD?

    1. JeffS Post

      I’m not the best person to answer these questions anymore as I’m no longer an employee for Quest. If you’re on Twitter I can recommend a few people that could help or of course you could call Support.

  2. Visual comparison of two databases is very powerful, this is the kinda stuff I like to learn about Toad (I only started using it for the first time this year). Keep up the good work !

    1. JeffS Post

      You just let me know what you’d like to see, and I’ll do my best to make it happen. The most vocal folks will get the most attention in this community 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *