Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Guys,
If you have document type that has field mutli text. If you change to rich text edit would existing data be lost or would it be preserved?
Regards
Ismail
Even if datatype should changed, just write a small sql script to copy your data from one column to the other one (cmsPropertyData table)
It keeps the data bud :)
Cheers although one more thing I should have mentioned its a uSiteBuilder site however should still be good?
Yup, you're good to go, haven't experienced any issue while changing datatype using usitebuilder.
/Dirk
Luckily both data-types use Ntext column to store their data, so yes - they are hot-swappable.
Following on from Dirk's answer, if you need to swap between columns, (e.g. Nvarchar to Ntext), there is a SQL snippet on this post:
http://our.umbraco.org/forum/using/ui-questions/21702-Switch-dbType-from-Nvarchar-to-Ntext-without-data-loss
Cheers, Lee.
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.
Continue discussion
Property change on document type
Guys,
If you have document type that has field mutli text. If you change to rich text edit would existing data be lost or would it be preserved?
Regards
Ismail
Even if datatype should changed, just write a small sql script to copy your data from one column to the other one (cmsPropertyData table)
It keeps the data bud :)
Guys,
Cheers although one more thing I should have mentioned its a uSiteBuilder site however should still be good?
Regards
Ismail
Yup, you're good to go, haven't experienced any issue while changing datatype using usitebuilder.
/Dirk
Luckily both data-types use Ntext column to store their data, so yes - they are hot-swappable.
Following on from Dirk's answer, if you need to swap between columns, (e.g. Nvarchar to Ntext), there is a SQL snippet on this post:
http://our.umbraco.org/forum/using/ui-questions/21702-Switch-dbType-from-Nvarchar-to-Ntext-without-data-loss
Cheers, Lee.
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.