Updating the database structure

Campaign v7 documentation
Latest updates
Release Notes
- Get started with upgrades
- Latest release
- Previous releases
  - Gold Standard
  - 2021
  - 2022
- Deprecated features
- Compatibility matrix
Get started
- Start with Adobe Campaign
- Privacy
- Profile management
- Import and export data
- Filter data
- Create queries
- Permissions
- Data packages and enumerations
  - Data packages
  - Enumerations
- Connectors
Create and send messages
- Get started with messages
- Key steps when creating a delivery
- Send emails
- Send SMS
- Send LINE messages
- Send push notifications
- Send direct mail
- Use delivery templates
- Personalize deliveries
- Use seed addresses
- A/B testing
- Services and subscriptions
- Monitor deliveries
- Track messages
- Deliverability management
- Content management module
Orchestrate marketing campaigns
- About marketing campaigns
  - Design marketing campaigns
  - Access marketing campaigns
- Orchestrate campaigns
- Campaign optimization
Marketing Resource Management
- About marketing resource management
- Create and manage tasks
- Control costs
- Manage marketing resources
- Discussion forums
Distributed marketing
- About distributed marketing
- Create a local campaign
- Create a collaborative campaign
- Publish the campaign package
- Access campaigns
- Track a campaign
- Use cases
Response manager
- Get started with response manager
- Configuration
- Hypothesis templates
- Create hypotheses
- Hypothesis tracking
Design and share reports
- Get started with reporting
  - Reporting tools
  - Best practices for reporting
- Access built-in reports
  - About built-in reports
  - List of reports
- Reports on deliveries
- Analyze populations
- Create new reports
- Design reports with cubes
Design web content
- Web applications
- Edit HTML content
- Web forms
Create online surveys
- Get started with surveys
- Key steps to create a survey
- Design a survey
- Manage answers
- Publish, track and use collected data
- Configure surveys
- Use case: create a referral form
- Use case: display report on answers to an online survey
Integrate with Adobe Experience Cloud
- About Campaign integrations
- Audience sharing
- Asset sharing
- Adobe Experience Manager
- Adobe Target
- Adobe Experience Cloud Triggers
- Adobe Experience Platform Sources and Destinations
Automate with workflows
- Get started with workflows
- Execute a workflow
- Targeting activities
- Flow control activities
- Action activities
- Event activities
- Use cases
- Monitor workflows
- Advanced management
Manage Offers
- Get started with Interaction
- General operation
  - Implementation steps
  - Fundamental principles
- Manage environments
- Manage an offer catalog
- Offers simulation
- Deliver an offer
- Unitary interactions
- Track offers
  - Offer proposition history
  - Offer analysis report
- Advanced parameters
- Use case
Transactional Messaging
- Get started with transactional messaging
- Configure transactional messaging
- Message templates
- Transactional event processing
- Reports
- Use case
Integrate with social media
- About social marketing
Installation and configuration guide
- Architecture principles
  - General architecture
  - Hosting models
    - Campaign hosting models
    - Capability matrix
- Deployment types
- Security and privacy settings
- Install Campaign (on-premise)
- Deploy Campaign (on-premise)
- Configure Campaign
- Connect to Campaign
- Connect Campaign to external systems
  - Configure external accounts
  - Configure Federated Data Access
- Appendices
Monitoring guide
- Introduction
- Production procedures
- Data processing
- Update Adobe Campaign
- Database maintenance
- Troubleshooting
Developers guide
- Data model
- Schema Reference
  - About schema reference
  - Schema structure
  - Database mapping
  - Elements and attributes
    - Introduction
    - Attribute
    - Compute string
    - Condition
    - DB index
    - Element
    - Enumeration
    - Help
    - Join
    - Key
    - Keyfield
    - Method
    - Methods
    - Param
    - Parameters
    - SrcSchema
    - Sysfilter
    - Value
- Editing schemas
- Input forms
- API
- Navigation hierarchy
  - Configure the Explorer hierarchy
  - Edit the Explorer hierarchy
- Use a custom recipient table
- Setting up web tracking
Technotes
- Hardware sizing recommendations
- Upgrade to IMS
  - Migrate users to IMS
  - Migrate technical operators to Developer Console
- Upgrades and compatibility
- Emails and push notifications
- Migration to Adobe Managed Services
  - Migration to Public Cloud
  - FAQ
Campaign Control Panel

Related Topics

Related Content

Documentation

Campaign Classic v7

Campaign Classic v7 Documentation

Updating the database structure

Last update: 2023-08-31

Topics:
Configuration
View more on this topic

Created for:
Developer

To apply the modifications made to the schemas, launch the database update wizard. This wizard is accessible via Tools > Advanced > Update database structure . It checks whether the physical structure of the database matches its logical description and executes the SQL update scripts.

The modules in the database are automatically populated and activated.

The Add stored procedures and Import initialization data options are used to launch the initial SQL scripts and the data packages executed when the database is created.

You can import a set of data from an external data package. To do this, select Import a package and enter the XML file of the package.

Follow the steps and view the database update SQL script: