Subject | Re: [firebird-support] SQL statements from all views |
---|---|
Author | Norman Dunbar |
Post date | 2011-05-26T12:03:24Z |
Afternoon,
isql -x <database> -user xxx -password yyyyy
You can redirect the output to a file as follows:
isql -x <database> -user xxx -password yyyyy > listing.sql
All on one line if it has wrapped in transit.
HTH
Cheers,
Norman.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
> I would like to made some migration tool and I need to get SQL statement of all views from my FirebirdSQL database. Is this possible and how to get this scripts?How about running isql to extract the metadata for the whole database:
isql -x <database> -user xxx -password yyyyy
You can redirect the output to a file as follows:
isql -x <database> -user xxx -password yyyyy > listing.sql
All on one line if it has wrapped in transit.
HTH
Cheers,
Norman.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767