PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • How to proceed?
  • Converting the structure of a database from WDSQL
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
WDSQL is used to convert the structure of a HFSQL database into SQL script. Then, this script can be run on an SQL database to create the database corresponding to the HFSQL analysis.
This option is used for example to simplify the creation of an analysis on an Oracle database from an existing analysis in WINDEV format.
Note: To convert the structure of a HFSQL database, you must be connected to an SQL database. This connection is used to identify the types of columns recognized by the selected SQL database. Theses types of columns will be used when exporting the HFSQL database to the SQL database.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
How to proceed?

Converting the structure of a database from WDSQL

To convert the structure of a database from WDSQL:
  1. Connect to an SQL database. See Connecting to a database for more details.
  2. Select "Tools .. Analysis conversion" or click . The wizard for analysis conversion starts.
  3. Select the WINDEV analysis to convert (".WDD" file).
  4. Specify (if necessary) the password of this analysis (runtime password defined in the analysis description.
  5. Select the directory containing the data files of the analysis to convert and go to the next step.
  6. Select the data files that must be converted to SQL format and go to the next step.
  7. The generated conversion script is displayed in the wizard.
    Note: In the wizard, you can:
    • modify this script,
    • find an expression in this script,
    • replace the expressions found by another expression.
  8. Validate. The SQL code of the generated script is automatically displayed in the main window of WDSQL.
Note: This script can be:
  • modified in the main window of WDSQL,
  • saved ("File .. Save a query" or ),
  • run ("Execution .. Run a script in batch" or ).
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment