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.
To create a database subset:
- Define the records to include using a subset definition.
- Create the database subset in either Microsoft™ Access or SQL Server.