ApexSQL Knowledgebase: What files should be backed up to copy settings of one ApexSQL Edit 2008.06 installation to another location?

LINKS

General

ApexSQL Audit
ApexSQL Clean
ApexSQL Data Diff
ApexSQL Debug
ApexSQL Diff
ApexSQL Diff API
ApexSQL Doc
ApexSQL Edit
ApexSQL Enforce
ApexSQL Log
ApexSQL Log API
ApexSQL Recover
ApexSQL Refactor
ApexSQL Script
ApexSQL Source Ctl
ApexSQL SSIS Compare

Knowledgebase Home

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly.

FAQs

Quick answers to common questions.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools.

Online Documentation

All of our help files for download or convenient viewing online.

Videos

Watch product demos, training videos, or tutorials of our products' main features.

ApexSQL Knowledgebase

Tips and How-to Articles for ApexSQL Tools

What files should be backed up to copy settings of one ApexSQL Edit 2008.06 installation to another location?

DESCRIPTION
This article describes what files should be backed up if you want to copy settings of your ApexSQL Edit installation to another computer.

SOLUTION
You need to back up files and directories listed below if you want to copy your ApexSQL Edit settings:

   Note: we use the following variable names in the directory listing below:
      $InstallFolder$ variable should be replaced by your installation folder, for example C:\Program Files\ApexSQL\ApexSQL Edit,
      $MyDocuments$ variable should be replaced by your Documents and Settings folder, for example C:\Documents and Settings\Administrator\My Documents\ for Windows XP or \Users\$UserName$\Documents\ApexSQL\ApexSQLEdit2008 for Windows Vista,
      $UserAppData$ variable should be replaced by your Application Data folder, for example C:\Documents and Settings\Administrator\Local Settings\Application Data\ApexSQL\ApexSQLEdit for Windows XP or \Users\$UserName$\AppData\Local\ApexSQL\ApexSQLEdit for Windows Vista:

• $InstallFolder$\Report Templates the folder that stores your report definitions,
• $InstallFolder$\SQL Templates the folder stores SQL template files which appear as new commands under main menu File (default ones are New Stored Procedure and New User Defined Function commands),
• $InstallFolder$\edit.project the file that stores your startup default project settings,
• $InstallFolder$\BlankQuery.xml the default blank (new) query file,
• $InstallFolder$\Favorites.xml this file stores the list of selected favorite Schema Explorer nodes (objects) which appear under reserved schema folder named “Favorites”,
• $InstallFolder$\Options.xml this file stores information about ApexSQL Edit options and configuration (including Source Control connections and setup),
• $InstallFolder$\Queries.xml the file stores user defined queries,
• $InstallFolder$\Replacements.xml this file stores definitions of auto replacements,
• $InstallFolder$\Layouts.xml this file stores information about user interface configuration such as window sizes, positions, panel setup, etc; please note that 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,
• $MyDocuments$\ApexSQL\ApexSQLEdit2008 the folder is a default location for user files (projects, workspaces etc),
• $MyDocuments$\ApexSQL\ApexSQLEdit2008\Snippets\My Snippets the folder is a default suggested location of application and user defined Snippets,
Note: It is possible to store custom Snippets in subfolders of the $MyDocuments$\ApexSQL\ApexSQLEdit2008\Snippets folder. In such a case all subfolders created by a user should be also backed up.
• $MyDocuments$\ApexSQL\ApexSQLEdit2008\Templates\My Templates the folder is a default suggested location of application and user defined Templates,
Note: It is possible to store custom Templates in subfolders of the $MyDocuments$\ApexSQL\ApexSQLEdit2008\Templates folder. In such a case all subfolders created by a user should be also backed up.
• $UserAppData$\ApexSQL\ApexSQLEdit\Backup the application auto-backup history folder,
• $UserAppData$\ApexSQL\ApexSQLEdit\Settings the folder stores customization files for quick info, aliases, tab colors, macros, and more.

After you copy/backup up all necessary directories and files, you should paste/restore them into your corresponding destination folder(s).
Note: Remember that ApexSQL Edit application should not be run when you back up and restore the files/directories listed above.

AUTHOR
Anna Lesniak

LAST REVIEW DATE
20 August 2009

Labels: Apex SQL Edit

posted by Anna Lesniak on Thursday, August 20, 2009

0 Comments: