Kentico CMS 7.0 Developer's Guide

Data selection from MS SQL database

Data selection from MS SQL database

Previous topic Next topic Mail us feedback on this topic!  

Data selection from MS SQL database

Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic!  

This topic contains information about the part of Kentico Import Toolkit wizard specific for import from an MS SQL database. The preceding steps of the wizard are explained in the Initial steps topic.

 

6. In Step 4, you can choose from the following options:

 

Table - imports data from the table selected in the drop-down list. You can filter the imported data using a WHERE condition and sort them using an ORDER BY expression entered into the respective fields.

View - imports data from the view selected in the drop-down list. You can filter the data you want imported using a WHERE condition and sort them using an ORDER BY expression entered into the respective fields.

SQL query - imports data retrieved by a custom SQL query entered into the text area.

 

devguide_clip1975

 

When specified, click Next to proceed to the following step.

 

For the rest of the wizard, which is common for all the imported data sources, see the Final steps topic.