Red Gate forums :: View topic - Frustrations with Data Generator
Return to www.red-gate.com RSS Feed Available

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

Frustrations with Data Generator

Search in SQL Data Generator 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
gsuttie



Joined: 30 Nov 2005
Posts: 45
Location: Glasgow, Scotland

PostPosted: Wed Feb 05, 2014 12:08 pm    Post subject: Frustrations with Data Generator Reply with quote

I have one table which I want to insert 1000 rows, I want the primary key column to have identities 1-1000 - nothing I try seems to put the data in that order, it seems to aways randomise them even when the preview says 1, 2, 3, 4, 5.

Also a really useful addition would be to be able to have the option to script out the data using data generator so I can actually see whats about to be inserted before it goes ahead and does it.

To be able to script out the data would be a great addition unless I cant see how to do it.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6581

PostPosted: Thu Feb 06, 2014 5:43 pm    Post subject: Reply with quote

Hello,

I believe the ability to output the generated data to script or text file has already been mentioned here:
http://redgatesupport.red-gate.com/forums/22343586-SQL-Data-Generator

If you are referring to the preview window, you'll want to change the distribution setting from random to sequential in order to get the int generator to write the values in numerical order.

With SQL Server, even if data is generated in a certain order, you may find that when you retrieve it from SQL Server it comes back in a different order, because of the way MSSQL Server stores data. You may want to include an ORDER BY clause in the query if you want results sorted on a particular column in ascending or descending order.
Back to top
View user's profile Send private message
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