Page History
IDERA SQL Schema Compare 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 four the following sections:
- Workspace actions. Provides links that allow you to create a new workspace, add databases to the current workspace, compare schema, or change application settings. The New Workspace action resets the current workspace by erasing the comparison history and removing all registered databases.
- Databases/Snapshots. Contains the list of databases and snapshots that have been registered in the workspace. On mouse over two action links appear for a registered server:
- Edit. Allows you to change the connection settings for that server and/or add and remove databases.
- Remove. Un-registers a server (deletes all the server information from the workspace).
On mouse When you move your cursor over a database name two , the following action links related to that database appear:- Take a Snapshot. Allows you to take a snapshot of the schema of that database.
- Remove Database. Removes the database from the workspace.
- Comparison History. Displays up to 25 Contains the comparison sessions from the most recent one to the oldest one. You can rerun a session by clicking on itin the order specified in the Application Settings. Schema Compare provides one-click comparison, which allows you to return a comparison just by clicking a saved session.
- Output. Displays each workspace event as it occurs.
Saving and loading workspaces
Workspace Storage
The workspace stores its settings in a database file, which by default is: C:SQL Schema Compare Workspace stores the data in a set of xml files. There is always one master file that keeps SQL Server databases and credentials, and a separate xml file for each comparison session. The workspace is saved by default in a subfolder under the common folder for application data that is used by all users. It is usually found under \ProgramData\Idera\SQL comparison toolset\SchemaCompare\Workspace\workspace.
The workspace is managed automatically, so no action is required to save it or load it. However, if you wish to have multiple copies of the workspace, you can save it to a custom path. Functions for saving and loading the workspace are located in the quick menu of the application button:
| Info |
|---|
When you choose to save the workspace to a custom location, you specify the path and the name of the workspace master file. The session files are saved in the same directory as the master file, but their names will be auto-generated by SQL Schema Compare. Similarly, when you load a workspace from a custom location, you select the workspace master file. SQL Schema Compare expects the session files to be in the same folder as the master file. |
| Excerpt |
|---|
Total compare from data to schema with SQL Comparison Toolset. Learn more > > |
...
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 Schema Compare, open the Application Settings, and then change the workspace database to the file you created.
| Info |
|---|
The workspace requires write permissions to its database file. If it can't write to its database, it will display a read-only message. |