SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
FR: Data Transfer - Ignore timestamp fields

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
FR: Data Transfer - Ignore timestamp fields
Author Message
Mindflux



Joined: 25 May 2013
Posts: 610
Country: United States

Post FR: Data Transfer - Ignore timestamp fields Reply with quote
When transferring data from one DB to another, the timestamp fields throw errors because data cannot be inserted. I am going into each table in the transfer wizard and removing the timestamp fields from the transfer objects.

Is there a way to just have the data transfer ignore those entirely since it's a hard stop error?
Wed Nov 23, 2016 12:36 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Re: FR: Data Transfer - Ignore timestamp fields Reply with quote
Mindflux wrote:
Is there a way to just have the data transfer ignore those entirely since it's a hard stop error?


Importunately there is no such feature right now. You need to un-map such columns manually in the project settings for each column with timestamp or other auto-generated values that cannot be set explicitly.
Wed Nov 23, 2016 7:54 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Re: FR: Data Transfer - Ignore timestamp fields Reply with quote
SysOp wrote:
Mindflux wrote:
Is there a way to just have the data transfer ignore those entirely since it's a hard stop error?


Importunately there is no such feature right now. You need to un-map such columns manually in the project settings for each column with timestamp or other auto-generated values that cannot be set explicitly.



Enhancement #SA0030294 has been submitted for intelligent handling of destination columns with server auto-generated values and for identity columns.
Fri Dec 02, 2016 2:08 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 610
Country: United States

Post Reply with quote
Did this enhancement make it?
Wed Aug 09, 2017 10:08 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
Yes. The notes indicate it was completed in 9.1.207
Wed Aug 09, 2017 11:16 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.