Sample Employee SQL Server database with data

Question

Hi I need some sample SQL Server Employee database with data such as id, surname, name, age, adress etc. It must be quite big, I search with google, but I don't find any good sample. Can any body help ?

This question would be on-topic at http://opendata.stackexchange.com/ — Nicolas Raoul, Jul 24 '15 at 11:38

score 4 · Answer 1 · answered Mar 12 '10 at 08:30

4

The only tool I can think of is Red Gate Data Generator.

Otherwise, you'd be looking at someone's actual data or expecting someone to provide such a tool free of charge.

answered Mar 12 '10 at 08:30

gbn

422,506
82
585
676

score 1 · Answer 2 · edited Feb 03 '13 at 08:01

1

The Northwind database contains some sample employee data in a .mdf file which can be attached to SQL Server.

edited Feb 03 '13 at 08:01

Jim OHalloran

5,859
2
37
57

answered Feb 03 '13 at 07:38

meekash55

307
3
6

score 1 · Answer 3 · answered Mar 12 '10 at 08:29

You may find it a challenge to find such a database, privacy concerns prevent most publication of personal data such as you require. You may find one using pseudo-data, that is data that looks like what you want but is not about 'real' people. But you will probably find it easier to generate your own such pseudo-data. If you take this approach you can be sure that the data you generate meets your requirements too.

score 1 · Answer 4 · edited Aug 23 '11 at 10:15

1

This might not be Employee based, but is definitely worth having a look

AdventureWorks

edited Aug 23 '11 at 10:15

davidsleeps

9,393
11
59
73

answered Mar 12 '10 at 08:33

Adriaan Stander

162,879
31
289
284

score 1 · Answer 5 · answered Mar 12 '10 at 08:53

1

if you have access to Microsoft Visual studio for Database professionals it has a data generator built in which you can use link text

Also the AdventureWorks db also has a Employee table i think.

answered Mar 12 '10 at 08:53

Kev Hunter

2,565
4
25
39

score 0 · Answer 6 · answered Mar 12 '10 at 08:27

0

The old Northwind database has Employee table but that's quite small.

answered Mar 12 '10 at 08:27

hallie

2,760
19
27

Sample Employee SQL Server database with data

6 Answers6