Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Current »

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 Database.

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.

-sql "SELECT * From dbo.yourtablename"

If you are getting errors when you run the task it is worth checking which version of OGR you are on and updating to the latest.

  • No labels