sqldump - We want this command to map to the ADS Schema Script Generator code base. It would generate DDL and/or INSERT statements for a database (kind of like the MySQL sqldump). We want it to be able to write to stdout or a file. The command would export all items, and the user can choose whether to export DDL or INSERT or both. Would be nice if a user could choose the items if we can add an option to provide a list. This command will allow a user to dump and load any database from any vendor using \sqldump and \source command.
sqldump -d [--ddl] -i [--insert] -f FILE [ > stdout ]
Please clarify the followings:
(1)
>> sqldump - We want this command to map to the ADS Schema Script Generator code base.
>> It would generate DDL and/or INSERT statements for a database.
>> The command would export all items, and the user can choose whether to export DDL or INSERT or both.
What is the default operation that \sqldump should perform?
Generate DDL only by default? Or, generate both DDL and INSERT by default?
(2)
Should \sqldump support '-k, --session-d SESSION_ID' option as \sqlimport and \sqlexport?
sqldump should export DDL and INSERT by default. We should also support -k, --session-id
sqldump should export DDL and INSERT by default. We should also support -k, --session-id
The initial implementation of \sqldump is done. SVN r29614.
All of options implemented by the Schema Script Generator are supported by \sqldump, except the followings:
(1) Save as: One File Per Object
(2) Scripting Format: Use specific procedure name for file name (this is only valid for (1))
See \sqldump man page for more info.
Work yet to be finished:
(a) Need to provide an option to let user specify a list of objects.
(b) Need to do some more tests.
The initial implementation of \sqldump is done. SVN r29614.
All of options implemented by the Schema Script Generator are supported by \sqldump, except the followings:
(1) Save as: One File Per Object
(2) Scripting Format: Use specific procedure name for file name (this is only valid for (1))
See \sqldump man page for more info.
Work yet to be finished:
(a) Need to provide an option to let user specify a list of objects.
(b) Need to do some more tests.
Please clarify: For the list specified by user, I am assuming it is a list of fully qualified objects separated by comma. This means user can specify a list of objects from different databases and/or different schemas, is this what you are looking for? Supporting list of objects from different databases can be complicated, though.
Please clarify: For the list specified by user, I am assuming it is a list of fully qualified objects separated by comma. This means user can specify a list of objects from different databases and/or different schemas, is this what you are looking for? Supporting list of objects from different databases can be complicated, though.
SVN r29620:
(1) Add examples to man page.
(2) Terminate command thread ASAP once Control-C is pressed.
Discussed with Niels, we are not going to add an option for user to specify a list of objects for the time being.
SVN r29620:
(1) Add examples to man page.
(2) Terminate command thread ASAP once Control-C is pressed.
Discussed with Niels, we are not going to add an option for user to specify a list of objects for the time being.
Verified all options using ADStudio 12 RC 23 with a MySQL server.
Found bugs or future improvements should be added separately, like for instance: #7771 & #7773.
Closed.
Verified all options using ADStudio 12 RC 23 with a MySQL server.
Found bugs or future improvements should be added separately, like for instance: #7771 & #7773.
Closed.
Issue #7704 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build trunk/29614, 29620 |
No time estimate |
1 issue link |
relates to #7701
Issue #7701Add FluidShell command ermodeler |
Please clarify the followings:
(1)
>> sqldump - We want this command to map to the ADS Schema Script Generator code base.
>> It would generate DDL and/or INSERT statements for a database.
>> The command would export all items, and the user can choose whether to export DDL or INSERT or both.
What is the default operation that \sqldump should perform?
Generate DDL only by default? Or, generate both DDL and INSERT by default?
(2)
Should \sqldump support '-k, --session-d SESSION_ID' option as \sqlimport and \sqlexport?