Template exporting
If you create or edit a group of templates on a development or test Marketing OperationsDistributed Marketing server, you can export them and then import them to a production server.
The template export feature in Marketing OperationsDistributed Marketing allows you to export a group of templates or a single template. In either case, the system creates a self-contained ZIP archive; you can use this archive to import the templates to another Marketing OperationsDistributed Marketing server.
Export creates separate SQL scripts. These separate scripts give you more control over updating your database to work with the new templates when you import them. For example, if you need to add a column here or there, you can run only the create/alter scripts, so as not to needlessly delete tables and existing data.
The system generates the following script files (to use when you import the template archive).
| File | Description |
|---|---|
| create.sql | Adds columns to existing tables, and creates new tables that are needed for the templates. |
| createlkup.sql | Adds columns to existing lookup tables, and creates new lookup tables that are needed for the templates. |
| drop.sql | Deletes existing tables that are used by the templates. If you do not mind possibly deleting data, you run this script before create.sql to ensure that the database is set up correctly. |
| droplkup.sql | Deletes existing lookup tables that are used by the templates. If you do not mind possibly deleting data, you run this script before createlkup.sql to ensure that the database is set up correctly. |
| insertlkup.sql | Inserts data into the lookup tables. This script makes it possible to save complete lookup tables (schema plus data) with the template archive. |