Create advanced database subsets (SQL Server)

You can create a database subset from the records that are included in the results of running queries or sets that are specified in a database subset definition. If you use the Create Advanced Subset option, the subset database will be in Microsoft SQL Server format.

Before you begin

Before you can create a database subset, you need to specify the records that you want to copy to the new database by creating a database subset definition.
Note: Only database administrators can initialize the database for database subsets.

Procedure

To create an advanced database subset:
  1. Log on as a user that has the Database Creator role.
  2. Open the database from which you want to create the database subset.
  3. Select File > Data > Database Subsets > Create Advanced Subset.
  4. In the Name box, enter a name that will be used for both the subset security file and database subset.
    This also generates the Database Name displayed in the SQL Server (subset) section.
  5. The subset security file will be generated with the same users as the master database.
  6. Enter the Server connection URL in the Sever box, and enter your database credentials, these can be:
    • An exact duplicate of the credentials used to access the master database.
    • A specified user name and password
    • Windows Authentication
    Tip: Test your connection each time you change the server or the credentials used to access it.
  7. In Destination folder, browse to the folder where you want to create the subset security file and database identifier. You can create a new folder if you have sufficient Windows permissions. The folder you use can contain only one iBase database identifier and security file.
  8. In Subset Definition, browse for the definition that defines the data to be copied to the new database. At this stage, it is not possible to know whether the definition is valid.
  9. Click Create to continue.
    You will be warned if the definition is invalid if it contains parameterized queries, deleted queries or sets, or if the total number of records exceeds the record limit (5 million).
  10. Click OK to create the database subset.