| Subject | Re: [firebird-support] SQL statements from all views |
|---|---|
| Author | Ann Harrison |
| Post date | 2011-05-26T14:43:08Z |
On Thu, May 26, 2011 at 7:49 AM, majstor <majstoru@...> wrote:
isql - use the -x switch - then edit it down to the views you need. A
harder alternative is to look at the isql code and find the routine that
recreates view definitions. The code is open source, so you can use
it internally with no restrictions. If you choose to deploy your tool
outside your organization, you'll need to publish changes you make
to the Firebird code. But in all likelihood, you can use the code
unchanged, or write something new based on what you learn from
isql.
Best regards,
Ann
> Hi,The easiest thing to do is to extract the full database metadata with
>
> 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?
>
isql - use the -x switch - then edit it down to the views you need. A
harder alternative is to look at the isql code and find the routine that
recreates view definitions. The code is open source, so you can use
it internally with no restrictions. If you choose to deploy your tool
outside your organization, you'll need to publish changes you make
to the Firebird code. But in all likelihood, you can use the code
unchanged, or write something new based on what you learn from
isql.
Best regards,
Ann