?
Solved

Auto-generate Dummy Records (SQL Server)

Posted on 2006-11-21
7
Medium Priority
?
734 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
  • 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
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

850 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