How to Extract a Piece of Data Using Conditions

Sometimes you can encounter the situation when you need to migrate only a piece of data or a data cut and you know the conditions, on which this piece of data can be defined. There is a feature in Ispirer SQLWays Wizard tool that allows to control the data that should be migrated. So the user can set the conditions for each table if required.

To use this feature, please:

  1. Click on a required table
  2. Go to the “Data” tab
  3. Check the “Condition” option on this tab
  4. Provide conditions for how it can be done in WHERE clause in the text box, using the sql syntax of your source database.

For your reference, please see the screenshot below:

If after clicking the table name, you won't see the “Data” tab, please check whether you are using the tool in the “Expert Mode”. How to enable the “Expert mode” in the tool: How to Use SQLWays Wizard in Expert Mode

If you have any other questions, you are welcome to contact us:

More about Ispirer Systems