The workspace is the storage and the interface for saving and managing SQL Server databases, credentials, comparison sessions and other UI options. The workspace window is divided into 3 sections:
- Workspace action links - this section provides links that allow you to create a new workspace, add databases to the current workspace, compare database and view application settings. The "New Workspace" action resets the current workspace by erasing the comparison history and the registered databases.
- Registered Databases - contains the SQL Servers and databases registered in the workspace. Moving the mouse over a server or database reveals two action links: "Edit", which allows you to change the connection settings for that server and/or add and remove databases; and "Remove", which removes a server or a database from the workspace.
- Comparison History - contains up to 100 saved comparison sessions. To re-run a comparison, simply click on the saved session.
Workspace Storage
The workspace stores its settings in a database file, which by default is: C:\ProgramData\xSQL Software\SQL Server Comparison Bundle\DataCompare\Workspace\workspace.db. If you prefer to use a different file on a different folder, do the followings:
- Copy the default database file to a folder of your choosing. Rename it if you wish to do so.
- Launch data compare, open the Application Settings and change the workspace database to the file you created.
 |
The workspace requires write permissions to its database file. If it can't write to its database, it will display a read-only message. |