Preserves existing information about the table (synonyms, grants, etc.) when relinking into SQL.
Usage:
-sqlrefresh file xfd_file database_name
[-symb=table_name] [-prefix=table_prefix]
[-owner=user_name] [-conv=convention_ID]
[-rule=rules_file]
Description:
The ctutil -sqlrefresh command is very similar to the -sqlize command. The -sqlrefresh command has these properties:
Note: This is an administrative operation and therefore must be performed with caution. Do not attempt to use this operation on a file that is open. The <instance user> associated with the file for a sqlrefresh operation must have either DBA or RESOURCE SQL privileges in order for the operation to succeed or a c-treeRTG error 456 (group access denied) is returned. While strongly discouraged, backward compatibility is provided with this configuration option: COMPATIBILITY SQLIMPORT_ADMIN_PASSWORD.