Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Generate SQL Scripts with data?

Status
Not open for further replies.
redlam

redlam

MIS
Jun 28, 2000
218
US
Is there a way to generate SQL scripts for tables which would include the 'insert into' statements for the data contained within that table?<br><br>
 
Sort by date Sort by votes
TOAD does the first part of what you want to do.&nbsp;&nbsp;As for the INSERT statements I have seen MS Excel used where the volume of source data is small.&nbsp;&nbsp;You can use Excel to autogenerate the INSERT statements with a bit of fiddling, using concatenate.<br><br>Nick <p> Nick<br><a href=mailto:ndaniels@ventura-uk.com>ndaniels@ventura-uk.com</a><br><a href= > </a><br>If it's Data Warehousing or related then I want to know - but post it to the forum!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
139
carp
carp
mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
127
mmiah1982
mmiah1982
fredong
  • Locked
  • Question
Update upper row data with next row data that was detached partially from import.
Replies
6
Views
170
carp
carp
mikrom
  • Locked
  • Question
from a table with symmetric relation select every pair only once
Replies
0
Views
87
mikrom
mikrom
jchewsmith
  • Locked
  • Question
SQL Syntax 1
Replies
1
Views
109
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top