HDuplicateDatabase (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions

Use conditions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HDuplicateDatabase (Function)

In french: HDupliqueBaseDeDonnées

Available only with this kind of connection

Duplicates the database associated with a connection on an HFSQL server. The tables, the rights, the procedures and the triggers are duplicated.

Example

HDuplicateDatabase(MyConnection, "MyCopiedDatabase")

Syntax

<Result> = HDuplicateDatabase(<Connection> , <Duplicated database> [, <Progress Bar>])

<Result>: Boolean

True if the database was duplicated.
False if an error occurred. HError is used to identify the error.

<Connection>: Character string or Connection variable

Connection associated with the database to duplicate. This connection corresponds to:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a variable of type Connection.

<Duplicated database>: Character string

Name of the new database to create (copy of the current database).
Remarks:
The new database to create must not exist.
A WLanguage error occurs if the new database already exists.

<Progress Bar>: Optional window or control name

Name of the window in which the progress bar will be displayed.
Name of Progress Bar control used to display the progress.
This option is not available.

Remarks

Use conditions

To duplicate a database, the user must have:

the rights to perform backups.
the rights to create databases.

Component: wd300hf.dll