WP Data AccessRemote Connections

Appearance

⚡ Remote Connections

SQL Server ​

📌 To use the remote connection wizard, you must first enable our Premium Data Service on your WordPress server.

PREPARATION ​

Ensure that our server can access your SQL Server instance.

CREATION ​

  1. Start the Data Explorer.
  2. Click the connect icon to open the remote connection wizard.
  3. Select Microsoft SQL Server from the connection type drop-down list.
  4. Fill out the remote database connection details.
  5. Enter a table name.
  6. Click the create button.

WP Data Access - Remote Connection Wizard - Connect SQL Server

📌 USAGE ​

  • SQL Server tables can be used just like WordPress tables and are supported by all plugin tools.
  • A primary key is required for data management and must be defined explicitly in WP Data Access.
  • Read the limitations before you start updating SQL Server tables.