|
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.
|
|
Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806,
Visits: 2,737
|
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
|
|
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.
|