Import/Export Server List

BryantBryant Posts: 20 Bronze 2
edited January 2, 2009 10:48AM in SQL Backup Previous Versions
Is there any way to conveniently import/export the server listing in SQL Backup 5? I would like to keep my laptop in sync with my desktop computer for when I am not in the office and need to check on my servers.

Thanks!
Bryant

Comments

  • There are two locations that the SQL Backup GUI uses to store user data, you can set up scripts, or use synchronisation software to copy these files:


    The first is the list of registered servers (in a small XML file called "Servers.dat"), which can be found in:

    c:\documents and settings\%current_user%\application data\red gate\sql backup
    This file needs to be copied to get the list of servers as displayed in the GUI's treeview on the left hand side.


    The second is the client's activity history cache (which can be a considerable size - running into hundreds of megabytes in cases), which can be found in:

    c:\documents and settings\%current_user%\local settings\application data\red gate\sql backup\server data
    If you wish to use the SQL Backup GUI without having to transfer all of the activity history when first run (which if using a slow connection could be an issue), all of these files should be copied across. It is important that these are not copied when the GUI is open, as it could corrupt the data store.


    If you do copy the files over, any changes to the server list (changed authentication, new registered servers etc) would need to be copied back to the desktop - copying the Servers.dat XML file. However you can probably get away with not copying the server data files back, since this will be updated on the desktop when it's next used anyway.

    Hope that helps,
    Jason
  • BryantBryant Posts: 20 Bronze 2
    That will do just fine.
  • sorry to bump up the old thread

    but this should be a Feature Request for next version as well
    It is MUCH easier to go to File -> Export servers, and pick a Save location

    vs digging deep into the hidden folder :)
    C:\Documents and Settings\jerryhung\Application Data\red gate\SQL Backup, and copy Servers.dat
    Jerry Hung
    DBA, MCITP
Sign In or Register to comment.