Altering attribute data type form String to Memo deleted the previous records in database.

[GauravPK]

Any Idea ?

• Converted datatype from string to memo
• Run Update Database.
• Past records in the columns are blank now when i am fetching back date records

Any approach to take as an advice or suggestion before converting from string to memo or any idea on how to take the backup of db in Adobe Campaign classic.

[Jonathon_wodnicki · Accepted solution]

Hi,

If you're fully hosted with Adobe you can request a DB restore, IIRC they keep at least 7 days of full snapshots.

Past that contact your local IT dept for DB backups or mad scientist for time travel.

In the future check over the update wizard's DDL and if necessary use alter statements in packageable SQL scripts to change columns.

Thanks,

-Jon