| By product |
| Other |
|
Knowledgebase Tips and How-to Articles for ApexSQL Tools What files should be backed up before copying ApexSQL Edit settings to another location or updating to a new version Applies to ApexSQL Edit Summary This article lists the files that should be backed up if you want to copy ApexSQL Edit settings to another computer or update ApexSQL Edit to a new version Description Note: The following variable names are used: - %InstallFolder% C:\Program Files\ApexSQL\ApexSQL Edit - %MyDocuments% C:\Documents and Settings\Administrator\My Documents\ for Windows XP C:\Users\%UserName%\Documents\ApexSQL\ApexSQLEdit for Windows Vista/7 - %LocalAppData% C:\Documents and Settings\Administrator\Local Settings\Application Data\ApexSQL\ApexSQLEdit for Windows XP C:\Users\%UserName%\AppData\Local\ApexSQL\ApexSQLEdit for Windows Vista/7 - %VirtualStore% C:\Users\$UserName$\AppData\Local\VirtualStore\Program Files (x86)\ApexSQL\ApexSQLEdit2008 for Windows Vista/7 You need to back up the files and the directories listed below: - %InstallFolder%\Report Templates - %InstallFolder%\SQL Templates - %MyDocuments%\ApexSQL\ApexSQLEdit - default location for user files (projects, workspaces, etc) - %MyDocuments%\ApexSQL\ApexSQLEdit\Snippets\My Snippets - default location of application and user defined Snippets - %MyDocuments%\ApexSQL\ApexSQLEdit\Templates\My Templates - default location of application and user defined Templates, - %LocalAppData%\ApexSQL\ApexSQLEdit\Backup - the application auto-backup history folder - %LocalAppData%\ApexSQL\ApexSQLEdit\Settings - stores customization files for quick info, aliases, tab colors, macros, and more. - %LocalAppData%\ApexSQL\Common\DisplayedServers.xml - The list of servers available in the Connect to Server dialog - %LocalAppData%\ApexSQL\Common\LocatedServers.xml - The list of servers located in the Connect to Server dialog If the user has administrative rights, or UAC is turned OFF: - %InstallFolder%\edit.project - %InstallFolder%\BlankQuery.xml - %LocalAppData%\Favorites.xml - %LocalAppData%\Options.xml - %LocalAppData%\Queries.xml - %LocalAppData%\Replacements.xml - %LocalAppData%\Layouts.xml (this file shouldn’t be transferred to the new installation if the destination operating system has lower desktop resolution as it may cause some windows to become inaccessible or hidden) If the user has non-administrative rights, or UAC is turned ON: - %VirtualStore%\edit.project - %VirtualStore%\BlankQuery.xml - %VirtualStore%\Favorites.xml - %VirtualStore%\Options.xml - %VirtualStore%\Queries.xml - %VirtualStore%\Replacements.xml - %VirtualStore%\Layouts.xml (this file shouldn’t be transferred to the new installation if the destination operating system has lower desktop resolution as it may cause some windows to become inaccessible or hidden) Last updated November 30, 2011 Labels: Apex SQL Edit |
