Subject | Re: How to create automatically a .SQL file? |
---|---|
Author | chris.waldmann |
Post date | 2013-08-29T18:54:40Z |
--- In firebird-support@yahoogroups.com, W O <sistemas2000profesional@...> wrote:
I use IBExpert for this, but I don't now if the personal editon has this Export option.
You can use also FlameRobin
Happy coding
Christian
>Hi Walter
> Hello everybody
>
> In a Firebird's datatabase I have a large table with thousands of records,
> is there a simple way for send these records to a text file?
>
> My idea is to have a script with the "INSERT INTO" commands.
>
> Something like it:
>
> INSERT INTO MyTable(MyCol1, MyCol2, MyCol3) VALUES(1, 'Alicia', 444555);
> INSERT INTO MyTable(MyCol1, MyCol2, MyCol3) VALUES(2, 'Beatriz', 654321);
>
> So, when I initialize the database in another location I can put all those
> records into it using the INPUT command of ISQL.
>
> Greetings.
>
> Walter.
>
>
> [Non-text portions of this message have been removed]
>
I use IBExpert for this, but I don't now if the personal editon has this Export option.
You can use also FlameRobin
Happy coding
Christian