Creates a local synonym for a remote database. This functionality is used to create mappings to the four-part object names required by Cirro.

Syntax

CREATE REMOTE DATABASE localDBName ON systemName.databaseReference

Arguments

  • localDBName: The new, local name for the database. Enclose in double-quotes if this value contains special characters.

  • systemName: The remote system name.

  • databaseReference: The name of the existing database and catalog. This value is case sensitive.

Examples

CREATE REMOTE DATABASE "SQLServer2-Inventory" ON SQLServer2.Inventory;

See Also