Data tool transfer verisons fail

Posted By charlotte Sun 1 Apr 2018
Add to Favorites0
Author Message
charlotte
 Posted Sun 1 Apr 2018
Supreme Being

Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)

Group: Forum Members
Last Active: Wed 4 Apr 2018
Posts: 18, Visits: 358
Hi,

Trying to transfer data from database V2.8002 using data tool V2.908. Transfer fails to transfer product versions with the following error message.

Error in importing records from tblKartrisVersions --- <target>.V_Price and <source>.V_Price have conflicting properties: DataType property mismatch.

Can you please advise how this can be fixed.
Paul
 Posted Wed 4 Apr 2018
große Käse

große Käse - (251,465 reputation)große Käse - (251,465 reputation)große Käse - (251,465 reputation)große Käse - (251,465 reputation)große Käse - (251,465 reputation)große Käse - (251,465 reputation)große Käse - (251,465 reputation)große Käse - (251,465 reputation)große Käse - (251,465 reputation)

Group: Administrators
Last Active: Wed 18 Nov 2020
Posts: 805, Visits: 2,710
I believe the data types were changed around v2.9. We haven't done a lot of testing importing from older Kartris versions, as typically this is done using the upgrade scripts rather than the data tool these days. We left it in as legacy support, but it probably needs a health warning now.

The best way to upgrade a kartris db is using the sequential script updates. These run SQL code to add/update new settings, tables, stored procedures etc. and make other changes

If you take a backup of your v2.8 database, then clone it as a new db, you can then run the upgrade SQL scripts to bring it up to v2.9012.

https://kartris.tome.host/tc/9767


--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
charlotte
 Posted Wed 4 Apr 2018
Supreme Being

Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)Supreme Being - (5,763 reputation)

Group: Forum Members
Last Active: Wed 4 Apr 2018
Posts: 18, Visits: 358
Thanks
used the SQL upgrade scripts which worked so the website is now on the latest version.

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top