Icon

kn_​forum_​67024_​db_​postgres_​transfer_​data_​uuid

PostgreSQL - create data table with uuid - transfer data from H2 database to Postgres using Streaming

PostgreSQL - create data table with uuid - transfer data from H2 database to Postgres using Streaming

PostgreSQL - create data table with uuid - transfer data from H2 database to Postgres using Streaminghttps://forum.knime.com/t/copy-data-from-mysql-to-postgresql/67024/2?u=mlauber71 The Basics Of PostgreSQL UUID Data Typehttps://www.postgresqltutorial.com/postgresql-tutorial/postgresql-uuid/ Source DBtransfer the data in chunksof 50=> you can change thatH2data_insert_types123456H2data_insert_typesH2data_insert_typescontactsCREATE EXTENSION IF NOT EXISTS "uuid-ossp";CREATE TABLE contactsINSERT INTO contactscontacts2INSERT INTO contactsCREATE TABLE contacts2uuid_generate_v1POSTGRESdata_insert_types_transferPOSTGRESdata_insert_types_transfer=> create empty database based on the H2 DBPOSTGRES => change the target table to automatically create uuid columnsALTER TABLE "public"."data_insert_types_transfer" ADD COLUMN my_uuid_column UUID DEFAULT (uuid_generate_v4());POSTGRESdata_insert_types_transfer H2 Connector StreamingData Transfer DB Table Remover PostgreSQLConnector DB Table Creator DB Insert DB Table Remover DB SQL Executor DB SQL Executor DB Table Selector DB Reader DB SQL Executor DB Table Remover DB SQL Executor DB Reader DB Table Selector DB SQL Executor DB Table Remover DB Table Creator DB SQL Executor DB Reader Prepare Dummy Data PostgreSQL - create data table with uuid - transfer data from H2 database to Postgres using Streaminghttps://forum.knime.com/t/copy-data-from-mysql-to-postgresql/67024/2?u=mlauber71 The Basics Of PostgreSQL UUID Data Typehttps://www.postgresqltutorial.com/postgresql-tutorial/postgresql-uuid/ Source DBtransfer the data in chunksof 50=> you can change thatH2data_insert_types123456H2data_insert_typesH2data_insert_typescontactsCREATE EXTENSION IF NOT EXISTS "uuid-ossp";CREATE TABLE contactsINSERT INTO contactscontacts2INSERT INTO contactsCREATE TABLE contacts2uuid_generate_v1POSTGRESdata_insert_types_transferPOSTGRESdata_insert_types_transfer=> create empty database based on the H2 DBPOSTGRES => change the target table to automatically create uuid columnsALTER TABLE "public"."data_insert_types_transfer" ADD COLUMN my_uuid_column UUID DEFAULT (uuid_generate_v4());POSTGRESdata_insert_types_transferH2 Connector StreamingData Transfer DB Table Remover PostgreSQLConnector DB Table Creator DB Insert DB Table Remover DB SQL Executor DB SQL Executor DB Table Selector DB Reader DB SQL Executor DB Table Remover DB SQL Executor DB Reader DB Table Selector DB SQL Executor DB Table Remover DB Table Creator DB SQL Executor DB Reader Prepare Dummy Data

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2022-05-10
On NodePit since: 2023-05-16
Last update: 2024-11-24
Created with KNIME version: v4.7.2
Tags: sqlpostgrespostgresqluuidstreaming

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!