Red Gate forums :: View topic - View or Save Generated SQL?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

View or Save Generated SQL?

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jalbenberg



Joined: 15 Dec 2005
Posts: 4

PostPosted: Wed Jun 04, 2008 11:40 pm    Post subject: View or Save Generated SQL? Reply with quote

Is there any way to view or save the SQL that is generated from the execution of this program? If I am inserting 1 row into each of 250 tables, I would like to save the SQL Script with 250 insert statements.
Back to top
View user's profile Send private message
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Mon Jun 09, 2008 12:41 pm    Post subject: Reply with quote

Hello,

Thanks for your post. Currently, there is no way to view the SQL statements for the generation. However, i'll add the suggestion to the list for reviewing.

Regards

Ben
Back to top
View user's profile Send private message
DanAvni



Joined: 15 Jun 2005
Posts: 48

PostPosted: Wed Dec 10, 2008 11:14 am    Post subject: Reply with quote

please add this to the wishlist and work on it soon. we thought it was possible until today we inserted data to 20 tables (it took us a few hours just tweaking all the fields to the correct values) and then the data was inserted locally instead of on a remote machine where we actually need it.
_________________
Dan Avni
Back to top
View user's profile Send private message
kampak1111



Joined: 10 Aug 2008
Posts: 3

PostPosted: Mon Dec 22, 2008 4:23 pm    Post subject: Reply with quote

Hi,

It also the feature that is missing for me. Most of times I need a script that inserts generated data.

To get /save a script (as a workaround) I usually put two the same databases onto one (local) server, generate data against the first and then using the SQL Data Compare, I'm comparing these two databases. At the end of synchronisation (of SQL Data Compare) wizard there is an option to see the script and copy or save it.

This is the easiest way that I have found.
_________________
Kamil Pakur
Back to top
View user's profile Send private message
jarito



Joined: 02 Sep 2009
Posts: 2

PostPosted: Wed Sep 02, 2009 1:56 pm    Post subject: Reply with quote

You can easily do what you all are asking with several tools that are available. Once you generate the data into your test database, then use something like this:

http://www.codeproject.com/KB/database/ScriptDatabase.aspx


To dump that data to SQL scripts. I agree that it should be a feature in Data Generator to skip the extra step, but it is possible to do so right now.
Back to top
View user's profile Send private message
ptrubs



Joined: 21 Sep 2009
Posts: 1

PostPosted: Tue Sep 22, 2009 12:23 pm    Post subject: much needed feature Reply with quote

I agree, this is a much needed feature and would complete the package.

I'd rather run scripts for my deployments (or when generating test data for integration tests) rather than running the app as part of the build process.

strange that redgate should chose to omit this facility?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Tue Sep 22, 2009 1:26 pm    Post subject: Reply with quote

Under the hood SQL Data Generator doesn't generate DML INSERTs, instead it uses bulk inserting for performance reasons.

I guess we could log a feature request to generate a DML script as an alternative to applying the bulk insert directly to your database.

Kind regards,

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group