Toad World® Forums

Export and Import - Toad-SS 5.0.0.444 - SQL Script Import NEW Feature Request (MayBE) !!!


#1

To the Collective(Quest Guru(s) ) , Matt in Michigan and David Christian at a
range somewhere popping some round !!!

I have 437,035 rows of data from Yonder database and table I needed to extract
and place into a like table in Hither database and table.

A backup, zip, file transfer, unzip, restore was not an option since I am a very
old man, and I want to be alive when to see this finish…

So I used Toad-SS Export to delimited and Import on an pretty much idle system
(my Windows 7-64 Prof desktop) and was able to have enough system resources to
actually get this done AND in 15 minutes… Freak-n-amazing, I am shocked it
actually worked. David I believe you or Henrik wrote this code year ago, so I
will give you credit.

I also tried exporting the file to a SQL Script which also worked, but importing
a SQL Script …… Did not go so well .

Meaning it did not work, Because opening the SQL script exported file in Toad
SQL Server Editor … I got a Toad-SS fault on ‘out of system
resources (Memory)’ “ Imagine that”, which was expected
because the file is 360,631 KB…

Now I know that you know that I know that I could have run the SQL script on
OSQL and it would have worked just fine, but what I REALLY Wanted was a way to
run that large set of INSERTS in Toad.

I do not believe it is part of Import and Maybe it should be … I am just
asking the question: “Does anyone have any ideas on how else to have run
this exported SQL Script as an import, so as to fire up the insert statements
within the file as seen below?”

Otherwise, I am thinking of asking for a new feature which will read the file at
10,000 rows at a time and process them until end-of-file as part of the Import
functionality.

Note: This is not a:

image001.gif

image002.jpeg


#2

Hi Hank,

Regarding you initial question where you can run such huge script – I
don’t think that TSS Editor designed for such very big scripts.

As a solution for this particular case you can export to csv, use Bulk insert
etc. Or please tell me the reason you don’t want to do it in this way.

regards,

Alexander
image001.gif


#3

Hi Hank,

Regarding you initial question where you can run such huge script – I
don’t think that TSS Editor designed for such very big scripts.

As a solution for this particular case you can export to csv, use Bulk insert
etc. Or please tell me the reason you don’t want to do it in this way.

regards,

Alexander
image002.jpeg


#4

Hi Hank,

Regarding you initial question where you can run such huge script – I
don’t think that TSS Editor designed for such very big scripts.

As a solution for this particular case you can export to csv, use Bulk insert
etc. Or please tell me the reason you don’t want to do it in this way.

regards,

Alexander


#5

Alex, thanks for the reply.

I understand what you are saying and why, which is basically the running of a
large amount of Insert statements is outside the scope of toad-SS to load and
execute.

It clearly is within scope to create a large in script with insert statements
using Toad-SS, just don’t expect to be able to run the script within toad.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image002.jpeg


#6

Alex, thanks for the reply.

I understand what you are saying and why, which is basically the running of a
large amount of Insert statements is outside the scope of toad-SS to load and
execute.

It clearly is within scope to create a large in script with insert statements
using Toad-SS, just don’t expect to be able to run the script within toad.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary


#7

Alex, thanks for the reply.

I understand what you are saying and why, which is basically the running of a
large amount of Insert statements is outside the scope of toad-SS to load and
execute.

It clearly is within scope to create a large in script with insert statements
using Toad-SS, just don’t expect to be able to run the script within toad.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image001.gif


#8

Life is hard © =)

regards,

Alexander
image002.jpeg


#9

Life is hard © =)

regards,

Alexander


#10

Life is hard © =)

regards,

Alexander
image001.gif