Database subsets

A database subset is a portion of records in the database that are copied into a separate database. This collection of records are selected by creating a database subset definition that consists of the results of queries and sets.

You might want to create a database subset for a number of reasons:
Creating an environment that matches your current production environment for testing or training.
Adding a smaller amount of real data from a production environment lets you test changes to the database, or train users in as close to the production environment as possible.
Working with a set of data that relates to a specific department or organization.
By creating an environment that only contains specified data allows sanctioned data to be shared.
A database subset can be created from a query at any time, unlike the information in a case, that is assigned as the data is added.
To create a database subset:
  1. Define the records to include using a subset definition.
  2. Create the database subset in either Microsoft Access or SQL Server.
The database subset can then be used independently, and if required, you can synchronize any changes with the original database.