How do I generate test data using only VS 2013?

Question

Post reply

How do I generate test data using only VS 2013?

Rod at work

SSC-Dedicated

Points: 34008
More actions
September 29, 2015 at 3:09 pm

#311924

I've been tasked to generate some test data (a few thousand rows) into a new table in a new database. This database is a whole new idea, so I can't write a query to pull pieces of data from other databases. I cannot consider any third party tools, such as what Redgate or Idera has to offer. I can't consider free tools such as what I've found on GitHub. I've been instructed to restrict myself to Visual Studio 2013 and whatever I can get that works within that.
Suggestions, please?
Kindest Regards, Rod Connect with me on LinkedIn.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 1

Start here...

http://www.sqlservercentral.com/articles/Data+Generation/87901/

http://www.sqlservercentral.com/articles/Test+Data/88964/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 2

Jeff Moden (9/29/2015)
Start here...
http://www.sqlservercentral.com/articles/Data+Generation/87901/
http://www.sqlservercentral.com/articles/Test+Data/88964/

Hi Jeff.....did you ever do "part 3"

"Coming up in Part 3, random names, characters, codes, and SSNs."

best wishes

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

J Livingston SQL (9/29/2015)
Jeff Moden (9/29/2015)
Start here...
http://www.sqlservercentral.com/articles/Data+Generation/87901/
http://www.sqlservercentral.com/articles/Test+Data/88964/
Hi Jeff.....did you ever do "part 3"
"Coming up in Part 3, random names, characters, codes, and SSNs."
best wishes

I haven't. Got attacked by a well know terrorist... "Bin Bizi". 😉 (On the serious side, my Dad was diagnosed with Cancer in May and I got busy on that. He died two months ago. Long story that I'll share sometime.)

Shifting gears, I have started writing again (finally). Thanks for the reminder on that one.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 4

Jeff...my sincere condolences....My Dad passed away a few years back after a long struggle with cancer...it aint easy my friend.

glad to hear you are going to writing again and look forward to some new articles.

best wishes

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Rod at work SSC-Dedicated Points: 34008 More actions · Answer 5

Jeff,

I'm very sorry to hear of your father's passing away. My father is still with me, for which I'm grateful. I can only imagine how hard that must have been.

Kindest Regards, Rod Connect with me on LinkedIn.