Getting Data Out of BACKTRACK – BACKTRACK Problem

Summary

This article explains two ways to get your data from BACKTRACK.

Symptoms

Often clients want to get data out of BACKTRACK so it can be manipulated or analyzed in a different software or system (such as Excel).

Explanation

Two known ways to get data out of BACKTRACK:

  1. Export using BACKTRACK Export feature

  2. Query using SQL Management Studio (for SQL database)

We highly recommend using Option #1 if possible.  Using BACKTRACK for both Import and Export takes allows the user to advantage of the checks the data to maintain referential integrity, meaning linkages to other tables are enforced.  This helps keep the user from accidentally corrupting the data.

Using Option #2 is the more direct approach.  However, without the data checking features, it will allows users to perform queries and make changes to the database that can make the data unusable for BACKTRACK or other applications.

Additional Comments

WARNING:

SQL Management Studio is a good tool to view and export data but should not be used by end users to manipulate or add data.

Related Articles:

KBA-01069-C4D4T5 – Export Setup in BACKTRACK

Updated on August 6, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support