🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.thirdparty
Article #84

Re: Tool for generating INSERT statements from IB 7.5 table data

#84
From: Holger Klemt
Date: Wed, 22 Aug 2007 07:55
27 lines
1661 bytes
FCI schrieb:
> Is there a tool for generating INSERT statements from IB 7.5 table data ?
> Thanks. 

www.ibexpert.com, also usable as commandline in scripts

details http://ibexpert.info/documentation/14940.html

short example

   OUTPUT 'C:\MyScripts\Data.sql' ASINSERT INTO "MyTable";
   SELECT * FROM MY_TABLE;
   OUTPUT;

interactive way inside the ibexpert ide:

http://ibexpert.info/documentation/15760.html

-- 
Best Regards

Holger Klemt

www.firebird-conference.com 18.-20.10.2007 Hamburg, Germany

The most Expert for InterBase and Firebird - www.ibexpert.com
HK Software - 26203 Wardenburg - Germany - info@h-k.de - www.h-k.de
Technical Details
Message-ID: <fah15o.l0.1@ibexpert.info>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <46cb8bee@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: f688a,433ec33a44748ab9
X-Google-Attributes: gidf688a,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Message-ID: <fah15o.l0.1@ibexpert.info>
Date: Wed, 22 Aug 2007 09:55:03 +0200
From: Holger Klemt <hklemt@h-k.de>
User-Agent: Thunderbird 2.0.0.5 (Windows/20070716) Hamster/2.1.0.11
MIME-Version: 1.0
Newsgroups: borland.public.interbase.thirdparty
Subject: Re: Tool for generating INSERT statements from IB  7.5 table data
References: <46cb8bee@newsgroups.borland.com>
In-Reply-To: <46cb8bee@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 000767-2, 20.08.2007), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 85.16.11.234
X-Trace: newsgroups.borland.com 1187769396 85.16.11.234 (22 Aug 2007 00:56:36 -0700)
Lines: 27
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail