Start a new topic

Append mode between SQL Server and PostgreSQL

We edit a very basic mapping from a SQL Server table to the same table in PostgreSQL technologie. This mapping has just one filter on the source table.

The goal is to truncate the cible table and after to load it with source data with one filter on the source table.

The mapping bring two template and even with the "append mode" there is an intermediate table wich is create (and drop at the end).

We would like to have a direct "select ... from <source> where <clause>" and after a "insert into <cible> values ( :field1 , :filed2 , ...)" without temporary table.

Is it possible with standard template or do we have to create our specific template ?

Login to post a comment