Setting Up The Sample Database

The sample database is required to run the unit tests that are available with the sample Connectors. Before you set up the database, make sure the supporting database applications are installed as described in Requirements.

To create the sample database needed to test TIBCO Scribe® Connectors:

  1. Open Microsoft SQL Server Management Studio:
    1. Start the Query Browser
    2. Open the \Samples\SampleRSSourceDatabase\ directory.
  2. Run the first script SampleRSSource.sql. This script creates the sample database, ScribeSampleRSSource.
  3. Run the second script SampleRSSourceData.sql. This script populates the database with sample data.

    You can repeat this step at any time during testing, such as after testing the delete operation, to remove all previous changes and repopulate the database.

You must run the scripts in order. The order of operations mirrors how the TIBCO Scribe® production databases are created and populated.

The database change history is required because new records are automatically discovered, but finding deleted records without a change history requires an inefficient and time-consuming comparison between the source and target databases.

See Also

Sample CDK Projects