Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

How to on/off INDENTITY INSERT in Visual Importer ETL 8 years 7 months ago #4613

  • Charles
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 28
  • Thank you received: 0
Hello

I am migrating data from source DB to Ms SQL Server using Visual Importer ETL.
Both source and target tables have identity column.
what should I do to migrate same identity column value from source DB to target?

Note : I have 200+ tables in this scenario.

Charles

Please Log in or Create an account to join the conversation.

Re: How to on/off INDENTITY INSERT in Visual Importer ETL 8 years 7 months ago #4614

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7910
  • Karma: 33
  • Thank you received: 488
Put

SET IDENTITY_INSERT [ database. [ owner. ] ] { table } ON

In SQL before

SET IDENTITY_INSERT [ database. [ owner. ] ] { table } OFF

and in SQL after

Mike
Mike

Please Log in or Create an account to join the conversation.

Re: How to on/off INDENTITY INSERT in Visual Importer ETL 8 years 6 months ago #4706

I also have the same question. Will try this one out and hope it works.
Went down deep!!

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 105 guests and no members online