Versions Compared

Old Version 7

changes.mady.by.user Kim Stimpson

Saved on

compared with

New Version Current

changes.mady.by.user Kim Stimpson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Page Properties
hiddentrue
idKB

Theme

Data Import

Type

MS SQL Server

Available from

Overview

You have data in tables in an MS SQL Server database and want to use iShare Studio Workflow to import this data into your PostgreSQL Databasedatabase.

Step-by-step guide

  1. Refer to Workflow MS SQL Server Configuration if you haven’t already configured iShare to use an MS SQL Server connection.

  2. Create a new Workflow Spatial Data Transformation Task and select the Connection that relates to your MS SQL Server database.

  3. Select the Output Database and Table as required.

  4. The Source Data Table drop down isn’t populated so click on Show expert mode and use the following parameter in the Additional parameters field replacing “yourtablename” with the name of the table you wish to import data from.

...