Data tool transfer verisons fail


https://forum.kartris.com/Topic7027.aspx
Print Topic | Close Window

By charlotte - Sun 1 Apr 2018
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.
By Paul - Wed 4 Apr 2018
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
By charlotte - Wed 4 Apr 2018
Thanks
used the SQL upgrade scripts which worked so the website is now on the latest version.