?
Solved

Auto-generate Dummy Records (SQL Server)

Posted on 2006-11-21
7
Medium Priority
?
729 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 2000 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
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.

771 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