🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: borland.public.interbase.thirdparty
7 messages
7 total messages Started by FCI Wed, 22 Aug 2007 01:05
Tool for generating INSERT statements from IB 7.5 table data
#81
Author: FCI
Date: Wed, 22 Aug 2007 01:05
2 lines
1019 bytes
Is there a tool for generating INSERT statements from IB 7.5 table data ?
Thanks. 
Re: Tool for generating INSERT statements from IB 7.5 table data
#82
Author: Bill Todd
Date: Wed, 22 Aug 2007 01:15
10 lines
1108 bytes
FCI wrote:

> Is there a tool for generating INSERT statements from IB 7.5 table
> data ?  Thanks.

Other than a SELECT statement none that I know of. What are you trying
to accomplish?

-- 
Bill Todd (TeamB)
Re: Tool for generating INSERT statements from IB 7.5 table data
#83
Author: Martijn Tonies
Date: Wed, 22 Aug 2007 06:30
21 lines
1550 bytes
Hi,

> Is there a tool for generating INSERT statements from IB 7.5 table data ?

You mean a tool that creates a SQL script from data in a table?

Database Workbench can do that if you use "Export Data":
http://www.upscene.com/documentation/dbw/tools_dataexport.htm



-- 
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
Re: Tool for generating INSERT statements from IB 7.5 table data
#84
Author: 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
Re: Tool for generating INSERT statements from IB 7.5 table data
#85
Author: Craig Stuntz TeamB
Date: Wed, 22 Aug 2007 14:55
13 lines
1565 bytes
FCI wrote:

> Is there a tool for generating INSERT statements from IB 7.5 table
> data ?

	IBConsole. Go to the metadata tab in the table editor, tick "Include
table data."

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Borland newsgroup denizen Sergio Gonz�lez has a new CD of 
  Irish music out, and it's good: http://tinyurl.com/7hgfr
Re: Tool for generating INSERT statements from IB 7.5 table data
#86
Author: Quinn Wildman (CodeGear Develope...
Date: Wed, 22 Aug 2007 16:29
8 lines
1349 bytes
The InterBase Milking Machine. It's on the companion tools CD. Also, can 
be downloaded from http://cc.codegear.com/Item/16666

FCI wrote:
> Is there a tool for generating INSERT statements from IB 7.5 table data ?
> Thanks. 
> 
> 
Re: Tool for generating INSERT statements from IB 7.5 table data
#87
Author: FCI
Date: Thu, 23 Aug 2007 01:30
20 lines
1712 bytes
Darn, I knew IBConsole could do it - I didn't see that checkbox.

Thanks to all.


"Craig Stuntz [TeamB]" <craig_stuntz@nospam.please [a.k.a. acm.org]> wrote 
in message news:46cc4e52$1@newsgroups.borland.com...
> FCI wrote:
>
>> Is there a tool for generating INSERT statements from IB 7.5 table
>> data ?
>
> IBConsole. Go to the metadata tab in the table editor, tick "Include
> table data."
>
> -- 
> Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
>  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
> Borland newsgroup denizen Sergio Gonz�lez has a new CD of
>  Irish music out, and it's good: http://tinyurl.com/7hgfr 
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads