Visual Studio Database Professional (VSDBP)- Data Generation.
Our DBA came by the other day to let us know our database was complete. We were pleased to begin coding against it only to find that it had no data. Although we neglected to add data we did not neglect to turn on referential integrity, which means it's a pain in the *** to populate. The dilemma we now faced was how to generate data so we can begin working. Enter VSDBP and it's data generation capability. You can see in the image below what the generated data looks like (bottom left). The column "CollegeName" uses a regular expression to limit the generated data so that we do not generate a 'Y' with a tilda above it (look at LastUpdatedBy). I just wanted to say that VSDBP isn't released yet but its already shown it's worth to me and my team.
Visual Studio Database Professionals is currently in CTP1 which basically means it will crash on you...constantly. All that aside however it's going to be a sweet tool whether you're a DB or not you'll have to learn it. (yes I know it's a preposition)
Pete Orologas
Download VSDBP