An overview of the data source management tools

There is a set of useful tools in Schematic Dataset Editor to help in the management of data sources. These tools, their purpose, and the context in which they may be used are briefly listed below:

Action

Tool/Command

Context

Finding all data sources that are not in use

Identify unused data sources

  • Diagrams that referenced those data sources have been deleted.
  • User may have changed diagram versions, and some versions are not used anymore.

Deleting data sources

  • Diagrams have been deleted.
  • The reference version has been deleted.

Changing the server/instance/database connection properties for a set of data sources

Edit Connection Properties

  • Redefine invalid data sources.
  • Server is shut down, and there is a backup database.
  • Switch to another environment (from Production environment to Test environment, or conversely).

Searching diagrams based on a particular data source

Find Diagrams By Data Source

  • This data source is not valid anymore.
  • Before changing their reference version.

Changing the reference version for diagrams based on version data

  • The version has been deleted.
  • The version has been posted.

Checking data sources status

  • Identify data sources that cannot be opened.

Related Topics


Published 6/7/2010