Solved

Auto-generate Dummy Records (SQL Server)

Posted on 2006-11-21
7
727 Views
Last Modified: 2012-05-05
I need to populate a SQl Server 2005 table with dummy records.  My boss says this is a new 2005 feature, and I cannot use SQL statements. Any Ideas???
0
Comment
Question by:servicegroup
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 8

Accepted Solution

by:
drydenhogg earned 500 total points
ID: 17988323
If the feature exists, I have never come across it, I would ask your boss to substanciate his claim. What makes it even more bizarre is to suggest it is a SQL Server feature, but that you are not to use SQL Statements to do it.

I'd be a very happy man if it existed, that's for sure.
0
 
LVL 3

Author Comment

by:servicegroup
ID: 17988566
She assured me that this feature exists, and a coworker witnessed the presentation.
0
 
LVL 8

Expert Comment

by:drydenhogg
ID: 17988683
Sounds like the 'presentation' is possibly from someone (vendor) with a product.

Thinking outside of SQL Server, I can't remember the datadude ctp's having it, and Im trying to think whether perhaps they are thinking of something from visual studio team studio - test edition, there are test generation tools in that, in terms of creating code coverage through automatic parameter generation. Possibly they have seen a dmeonstration of something in that?



0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 3

Author Comment

by:servicegroup
ID: 17988815
It was a microsoft conference, and they assured me it was done on SQL Server, not VS.
0
 
LVL 8

Expert Comment

by:drydenhogg
ID: 17988858
Drawing a blank then, nothing in SP2 added to do this that I have seen, not seen it as a base feature of 2005 - be a very happy man if it exists as a current feature, or is due in sp2 etc.
0
 
LVL 3

Author Comment

by:servicegroup
ID: 17988894
Thanks. I will post any good news.
0
 
LVL 3

Author Comment

by:servicegroup
ID: 18028180
SQLIS.com has a record generator for use in the Business Intelligence Development Studio, but it only creates string and numeric fields.  I guess it might be useful if you were not creating tables for the real world.
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question