Sets the current migrator used for configuration queries.

Syntax

---

SET MIGRATOR TO <MigratorName>

Usage

---

Use this statement to set the current migrator. The current migrator dictates where ElevateDB will retrieve the list of avalable migrator parameters when queries on the MigratorParams Table in the special Configuration Database are executed. The name provided must be a valid migrator name. You can find out which migrators exist by querying the Migrators Table in the Configuration database.


Examples

---

SET MIGRATOR TO "EDB"

Required Privileges

---

Any user can execute this statement.

SQL 2003 Standard Deviations

---

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