SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Sync SSMS Tools Pack Across Computers Using SyncToy

My favorite and most used feature of the SSMS Tools Pack is the query history. This feature has saved me a lot of time and effort. DBAs where I work are assigned both a desktop for normal day to day operations and a laptop for when we’re at home, meetings, travel, etc. Today I ran into a scenario that made me want to keep the query history of both machines in sync. I askedĀ Mladen Prajdic, the creator, about syncing across computers and he directed me to a blog post written by REAL SQL Guy that does just that. Unfortunately his method uses Dropbox which is blocked at work, so I needed an alternative. I use SyncToy from Microsoft regularly to keep other folders in sync, so I decided to do the same for this project. Using SyncToy manually means that both machines need to be powered on and can see each other on the network since there is no intermediary.

The first thing I did was to share the C:\SSMSTools folder on each machine so I can trigger the sync from whichever computer I’m sitting at. I then created a folder pair on each machine specifying the “Left” folder as the remote shared folder and the “Right” folder as the local one. I made sure to use the “Synchronize” setting so that changes can go both ways. Give it a name, click Preview and Run. Now I have my entire history from both machines available from either one.

Link Recap:


Posted by Anonymous on 7 October 2011

Pingback from  Dew Drop – October 7, 2011 | Alvin Ashcraft's Morning Dew

Posted by Dukagjin Maloku on 7 October 2011

Useful, thnx for the info!

Leave a Comment

Please register or log in to leave a comment.