Icon CREATE MIGRATOR

Creates a new migrator.

Syntax
CREATE MIGRATOR <Name>
MODULE <ExternalModuleName>
[DESCRIPTION <Description>]

Use this statement to create a new migrator. A migrator is used by ElevateDB to migrate a database from an external source to an ElevateDB database. The referenced external migrator module must already be created and available to the current session. Please see the Migrating Databases topic for more information.

Examples
-- The following statement creates a migrator for
-- use with the Borland Database Engine (BDE).

CREATE MIGRATOR "BDE"
MODULE "edbmigratebde"

Required Privileges
The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
ExtensionThis SQL statement is an ElevateDB extension
Image