Altering attribute data type form String to Memo deleted the previous records in database. | Community
Skip to main content
G
GauravPK
January 13, 2020
Solved

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

  • January 13, 2020
  • 1 reply
  • 1158 views

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.

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

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

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
January 14, 2020

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

Terms & ConditionsAccessibility statement

Loading footer...