Try OpenEdge Now
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.