Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
Level 1
GauravPK
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
GauravPK
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
GauravPK
Level 1

13-01-2020

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.

 

ACC Adobe Compaign Classic Data Elements

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

14-01-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

Answers (0)