Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Use SyncToy with SQL Server RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,
    We are looking to use a file replication tool (such as sync toy) to dual log SQL data on some busy content filtering servers world wide to update a central logging location.  The application does not support this 'feature' but does cache temp files of the data store prior to writing to the SQL DB.

    Is is likely sync toy will be able to run in the background and when it sees these temp files created, automatically copy them to the 2nd server?  These updates occur every 1 minute and although I have used Sync Toy in GUI for home use, I have not played with the command line function.  Would it have to run as a Windows AT job or does the application have built in functionality to see the updates and copy auto-magically? 

    If sync toy is not a viable option, anyone have a suggestion of another free application to accomplish this?

    Thanks ahead of time.
    Friday, December 11, 2009 4:36 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi, 
        Basicly you problem can be resolved with windows "Task Scheduler". Either with some scripts combination and run SyncToy through SyncToyCmd.exe -Rxxx.
    But SyncToy itselft does not have a feature to detect the changes/update then do sync auto.

    For details you can see the Shcedule SyncToy session in SyncToy help document.



    Hope this could be helpful!


    Thanks,
    Ping
    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Proposed as answer by Ping Lu Friday, December 11, 2009 8:14 AM
    • Marked as answer by Yunwen Bai Monday, December 14, 2009 11:54 PM
    Friday, December 11, 2009 8:14 AM