How to Export / Import _User table?

Posted by S33 on 28-Nov-2017 10:18

What is the best way to export the _User table and import it into a new database? (The export is from 10.2b; the import is into 11.7.1. Both are RedHat Linux Enterprise.)

I tried the simple export and import commands, but the import gives me an error:
_TenantId is a system field and its value cannot be updated. (16011)

Thanks in advance -- Jim (kicking himself, because he must have done this before...)

OpenEdge RDBMS - Forum
Posted by James Palmer on 28-Nov-2017 12:25

Good chance you have granted SQL permissions. You might also have views. The export from data admin won't do these. So you need to export those using sql92 scripts. If you search the kB you should find instructions.

All Replies

Posted by Peter Judge on 28-Nov-2017 10:22

IMPORT should work. You can specify skip fields with a caret/ ^ .
 

Posted by James Palmer on 28-Nov-2017 10:58

You can use the data admin tool to export/import user records. This works cross version.

Posted by S33 on 28-Nov-2017 11:05

Are there additional tables, besides _User that I'll need, if my intent is to bring "security" across as is?

Posted by James Palmer on 28-Nov-2017 12:25

Good chance you have granted SQL permissions. You might also have views. The export from data admin won't do these. So you need to export those using sql92 scripts. If you search the kB you should find instructions.

This thread is closed