Sample Header Ad - 728x90

Pentaho Data Integration - Kettle- Update Identity Column in Microsoft SQL Server

0 votes
1 answer
851 views
For migration purposes I need to migrate existing ID's from my old database to my new table in MS SQL Server. I can truncate my table in MS SQL Server and then adjust my database connection in Pentaho to 'SET IDENTITY_INSERT tablename ON'. Then I am able to insert my ID's through a table output step, but I want to be able to UPDATE my existing ID without truncating my table in MS SQL Server. Could this be possible using Pentaho?
Asked by sql_mind (17 rep)
Oct 28, 2019, 10:06 AM
Last activity: Oct 28, 2019, 10:47 AM