Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:faq:data-cut-extraction [June 04, 2018, 01:24:31 PM]
alexandr.kirpichny created
sqlways:faq:data-cut-extraction [June 08, 2018, 02:34:08 PM] (current)
anastasiya.shpakava
Line 6: Line 6:
 ====== How to Extract Piece of Data Using Conditions ====== ====== 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.  +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. 
-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.+There is a feature in the SQLWays Wizard tool that allows to control the data that should be migrated. And the user can set such conditions for each table if required.
  
-To use this feature please:+To use this featureplease:
   - Click on a required table    - Click on a required table 
   - Go to the "Data" tab    - Go to the "Data" tab 
-  - Please check "Condition" option on this tab  +  - Check the "Condition" option on this tab  
-  - In the text box provide conditions like it can be done in WHERE clause, using the sql syntax of your source database. +  - Provide conditions for how it can be done in WHERE clause in the text box, using the sql syntax of your source database. 
  
  
-For the reference please see the screen-shot below:+For the referencepleasesee the screen-shot below:
  
 {{:sqlways:users-guide:wizard:specify-ddl-data:table_options:s-tab-options:data_cut.png|}} {{:sqlways:users-guide:wizard:specify-ddl-data:table_options:s-tab-options:data_cut.png|}}
  
-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: [[http://wiki.ispirer.com/sqlways/faq/expert-mode|How to Switch to the Expert Mode]]+If after clicking the table name, you don't see the "Data" tab, check whether you are using the tool in the "Expert Mode". How to switch on the “Expert mode” in the tool, you can find here: [[http://wiki.ispirer.com/sqlways/faq/expert-mode|How to Switch to the Expert Mode]]
  
 \\ \\
-If you will have any other questions please feel free to mail us: [[[email protected]]]+If you have any other questions, you are welcome to contact us: [[[email protected]]]
  
  
sqlways/faq/data-cut-extraction.txt · Last modified: June 08, 2018, 02:34:08 PM by anastasiya.shpakava
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement