Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
-GSS-
Starting Member
1 Post |
 Posted - 2006-07-03 : 06:13:24
|
| Hi,I use SQL Server 2005 Dev Edition and am not new to making databases (then again, I've had enough experience and my dad does the same thing).I am (unfortunately) a university student and for my dissertation I am going to produce a SQL Server database with a strong emphasis on data mining.Obviously, for the data mining to be useful at all I need to produce loads and loads of test data.Fair enough, and there are applications which do this, such as EMS Data Gen, but can anyone recommend me any other data gen utilities? EMS Data Gen has poor handling of unique attributes, and as I am doing a car manufacturer this will give me problems when I come to the registration number attribute.Also, why are utilities for SQL Server (and Oracle at that) so expensive? This makes it out of my reach and makes it difficult to build a truly good database that will net me good marks, and demotivates me. :(Lastly, please feel free to recommend to me any utilities for SQL Server - such as performance monitors, backup utilities. Anything. But if they are priced utilities, they have to be sensibly priced (<£100), because I cannot yet afford to pay >£1k on such utiltiies.Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-03 : 07:54:23
|
| You don't need any utilities other than management studio to build a good database.As for test data I always build it myself.You presumably have scripts to populate the smaller lookup tables.You can build routines to populate the other tables too. Build them with parameters to specify the number of rows to put in a table and the weighting to be allocated to the number of each value.You should end up with a script (or scripts) that will build the database structure, populate tables with static data and populate it with test data.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
|
|
Generating test data in SQL Server