Author |
Message |
Mindflux
Joined: 25 May 2013 Posts: 851 Country: United States |
|
FR: Data Transfer - Ignore timestamp fields |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7963
|
|
Re: FR: Data Transfer - Ignore timestamp fields |
|
 |
 |
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7963
|
|
Re: FR: Data Transfer - Ignore timestamp fields |
|
 |
 |
 |
 |
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 |
|
 |
Mindflux
Joined: 25 May 2013 Posts: 851 Country: United States |
|
|
|
Did this enhancement make it?
|
|
Wed Aug 09, 2017 10:08 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7963
|
|
|
|
Yes. The notes indicate it was completed in 9.1.207
|
|
Wed Aug 09, 2017 11:16 am |
|
 |
|