Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
faq:migration-toolkit:data-cut-extraction [2019/07/19 11:25] darya.prikhodkina |
— (current) | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== 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: | ||
- | - Click on a required table | ||
- | - Go to the "Data" tab | ||
- | - Check the "Condition" option on this tab | ||
- | - 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: | ||
- | |||
- | {{:faq:migration-toolkit/data_cut.png|}} | ||
- | |||
- | 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: [[faq:migration-toolkit/expert-mode]] | ||
- | |||
- | \\ | ||
- | If you have any other questions, you are welcome to contact us: [[[email protected]]] | ||
- | |||
- | \\ | ||
- | ---- | ||
- | === More about Ispirer Systems === | ||
- | [[https://www.ispirer.com|Ispirer Home Page]] | ||
- | [[https://www.ispirer.com/products/database-migration|Database Migration]] | ||
- | [[https://www.ispirer.com/application-conversion|Application Conversion]] | ||
- | [[https://www.ispirer.com/download|Downloads]] | ||