New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
ISQL extract metadata one file per object [CORE3685] #4034
Comments
Commented by: Frank Schlottmann-Goedde (fsg) Not sure whether it is still helpful, but I have an ancient patch (4 years old) that exactly did this (and a bit more). I never found the time to integrate it into the main tree. Anyway here it is: ? isql.diff
|
Commented by: @asfernandes I don't think the 'enhancement' should be put in Firebird. VCS works great with full-script files. |
Commented by: Frank Schlottmann-Goedde (fsg) Not really. It is much easier to find changes to e.g. a procedure if they are in a single file and not cluttered round global changes to a single script. And at the time I wrote this patch it was not possible to recreate a database from the script isql creates without manual reordering. Not sure whether this is still the fact. |
Submitted by: Valdir Stiebe Junior (ogecrom)
Votes: 1
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.
The text was updated successfully, but these errors were encountered: