Toad World® Forums

Generate inserts of a table (.SQL)?


#1

Hi, there is a way to make Toad export all the inserts that was made into a specific table into a .sql file?

Thanks in advance!


#2

I use Toad for SQL Server 4.1.0


#3

Hi,
I’m afraid I don’t 100% understand where do you want to get this. Is it Data tab in object details? please add a bit more info.


#4

Hi,

There are plenty of ways to get insert statements of all your data from the table,
one of them is to try “Generate Data Script…” from Database context menu, or you can try export wizard.
Though I’m not sure first one is available in 4.x versions.

is there any specific reason you are using so old version of Toad? FYI: we are working on 6.0 at the moment.