6

is there a good freeware that generates fake data for SQL Server? It would be really great if the tool generate the data according to foreign key (other constraints). Its such a repetitive task I am sure there must be a good tool for this but somehow i cant seem to find it.

Baum mit Augen
  • 49,044
  • 25
  • 144
  • 182
Umair Ahmed
  • 11,238
  • 5
  • 33
  • 39
  • 1
    similar question..http://stackoverflow.com/questions/157600/data-generators-for-sql-server –  Aug 01 '09 at 02:31
  • check this.. http://stackoverflow.com/questions/16317/creating-test-data-in-a-database –  Aug 01 '09 at 02:36
  • Thanks for the links Amudhan. – Umair Ahmed Aug 01 '09 at 10:37
  • If you are using .NET, Bogus provides some really nice features to do this(https://github.com/bchavez/Bogus). Take a look at this blog post for details about how to use it: https://coderulez.wordpress.com/2017/05/10/net-core-generating-test-data/ – univ May 10 '17 at 18:45

3 Answers3

3

If you cannot find a free version, RedGate produce a commercial one called SQL Data Generator.

adrianbanks
  • 81,306
  • 22
  • 176
  • 206
2

other commercial tools. 1.EMS Data Generator for SQL Server

2.IRI RowGen, for multiple DBs and flat files, uses Eclipse GUI

3.Xentrix

Community
  • 1
  • 1
1

I've always written my own. It rarely takes very long to write. This way I know what I'm dealing with and if it's not correct, then I can tweak as needed and re-run it.

Dinah
  • 52,922
  • 30
  • 133
  • 149
  • 1
    If you are using .NET, Bogus provides some really nice features to do this(https://github.com/bchavez/Bogus). Take a look at this blog post for details about how to use it: https://coderulez.wordpress.com/2017/05/10/net-core-generating-test-data/ – univ May 10 '17 at 18:41