Exporting and Importing Your Data (as of 9.3g) -- Overview

Export and Import have been improved as of ListManager 9.3g.  These utilities allow you to migrate your data from your current ListManager database to another ListManager database on Oracle or MSSQL.

lm exporttofile will export all ListManager data into a file.

lm importfromfile will import that file into another database.

NOTE   You must upgrade ListManager to 9.3g to utilize the new Export / Import improvements.

What the Export Feature Will and Will Not Export

The export feature “lm exporttofile” WILL export:

• all tables and fields created by List Manager
• any custom fields created in the members_ and clickstreamdata_ tables that are one of the following types:

Postgres	translates to	MS-SQL	Oracle9
Bigint		numeric	number(20)
numeric		numeric	number
bigserial		numeric	number(20)
zdoubleprecision 8		float	float(22)
real		float	float(22)
zbytea		image	blob(4000)
zinteger		int	number
serial		int	number
smallint		smallint	number
text		text	clob(4000)
timestamp		datetime	date
timestamptz		datetime	date
char		char	char
varchar		varchar	varchar
money		varchar	varchar

** NOTE:  Any constraints or default values on user defined fields will not be exported.  You will have to add those manually to the imported database.

The export feature “lm exporttofile” will NOT export:

• any tables created by users
• any custom fields in tables other than the members_ and clickstreamdata_ tables

Next: Cleaning ListManager Data Before Exporting