Home » Infrastructure » Windows » Create SQL File
Create SQL File [message #220954] Thu, 22 February 2007 19:52 Go to next message
jayoung
Messages: 21
Registered: October 2005
Location: USA
Junior Member
I am needing dump a table from oracle into a .sql file from visual basic i would like it to create insert statements in the .sql file for the data so it can be imported into another DB, anyone got any ideas on how to do this. the other db is Sqlite so maybe there is another faster way of doing this to.


Thanks
Jay
Re: Create SQL File [message #221341 is a reply to message #220954] Mon, 26 February 2007 06:59 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Why you create .sql file just use EXPORT or IMPORT utility.

regards
Taj
Re: Create SQL File [message #221354 is a reply to message #221341] Mon, 26 February 2007 07:50 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Export (and Import) utilities would be fine if this another database ("Sqlite", as @jayoung said, and which I'm not sure what exactly is) was an Oracle database. If not, Oracle proprietary Export format will not be recognized by another database's utilities.
Re: Create SQL File [message #221366 is a reply to message #221354] Mon, 26 February 2007 08:13 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
imported into another DB
Actually OP is not clear for us.
Another DB of Oracle then EXPORT/IMPORT is best option.
Another DB of Other than Oracle DB. then EXPORT/IMPORT is not useful.

lets wait for OP reply.

regards
Taj
Re: Create SQL File [message #221375 is a reply to message #220954] Mon, 26 February 2007 08:30 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

OP says
jayoung wrote on Fri, 23 February 2007 02:52
the other db is Sqlite



I think it's very clear Wink
Previous Topic: oracle 10G
Next Topic: Which version of oracle suitable for windows 2000 or XP professional?
Goto Forum:
  


Current Time: Thu Mar 28 10:07:53 CDT 2024