Migrate client variable data

You should understand the structure of the database tables used to store client information if you have to migrate client variable data to another data source.

 

Client variables stored externally use two small database tables with the simple structure shown in the following tables:

 

CDATA

Column

Data Type

cfid

char(20)

app

char(64)

data

memo

 

CGLOBAL

Column

Data Type

cfid

char(20)

app

memo)

lvisit

date

 

Data types shown in these tables are those used for a Microsoft Access database. Your database will require different data types. For information about creating client variable tables, see the book Developing ColdFusion Applications.

Related topics