ISQL extract metadata one file per object
-----------------------------------------
Key: CORE-3685
URL: http://tracker.firebirdsql.org/browse/CORE-3685
Project: Firebird Core
Issue Type: Improvement
Components: ISQL
Reporter: Valdir Stiebe Junior
Priority: Minor
It would be very helpful if we could extract the metadata on separated files
for each object.
The command line could be: isql <database> -xf <target folder> -u sysdba -p
masterkey
The result would be text files on target folder with a file for each
table/stored procedure
TargetFolder/Domain DOMAIN_1.sql
TargetFolder/Table TABLE_1.sql
TargetFolder/Table TABLE_2.sql
TargetFolder/Trigger TABLE_1_BI.sql
TargetFolder/Procedure STP_1.sql
TargetFolder/Grants.sql
An extended version could use a folder structure to represent namespaces and
types of objects.
TargetFolder/Domains/DOMAIN_1.sql
TargetFolder/Tables/TABLE_1.sql
And so on.
I see two main use cases for this feature.
1. Allow store DDL on SVN (or any source code versioning system) repositories;
2. Allow easy database metadata comparison with tools like beyond compare,
tortoise merge etc;
Please point me to the right direction if this is already possible with ISQL.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
