Try OpenEdge Now
skip to main content
Multi-tenancy Overview
Multi-tenancy and OpenEdge SQL : SQL utility use cases : Dumping all tenant data as a super tenant or a DBA
 

Dumping all tenant data as a super tenant or a DBA

To dump the data to an SQL dump file for all the tenant partitions of a multi-tenant table:
sqldump -u dbaUser -a dba -t mttab1 progress:T:localhost:9999:sports3000
For this operation, the user, dbaUser, must be mapped to a DBA or a super tenant.