Issue Details (XML | Word | Printable)

Key: CORE-3685
Type: Improvement Improvement
Status: Open Open
Priority: Minor Minor
Assignee: Unassigned
Reporter: Valdir Stiebe Junior
Votes: 1
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

ISQL extract metadata one file per object

Created: 02/Dec/11 05:48 PM   Updated: 04/Dec/11 02:44 PM
Component/s: ISQL
Affects Version/s: None
Fix Version/s: None


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.