Ispirer Ispirer
 

This is an old revision of the document!



Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

How to Extract Piece of Data Using Conditions

Sometimes may appear situation when you will need to migrate only a piece of data or a data cut and you know the conditions, how this piece of data can be defined. So there is a feature in the SQLWays Wizard tool that allows to control the data that should be migrated. And user can set such conditions for each table if required.

To use this feature please:

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

For the reference please see the screen-shot below:

If after clicking the table name, you don't see the “Data” tab, please check whether you are using the tool in the “Expert Mode”. On how to to switch the tool to the “Expert mode”, you can find here: How to Switch to the Expert Mode


If you will have any other questions please feel free to mail us: support@ispirer.com


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/faq/data-cut-extraction.1528118671.txt.gz · Last modified: June 04, 2018, 01:24:32 PM (external edit)
 
© 1999-2020, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement