http://deepdark.net/ .NET, SQL Server and *.* http://deepdark.net/files/deepdark.jpg http://deepdark.net/ en-us James Green Thu, 31 Aug 2006 23:16:57 GMT newtelligence dasBlog 2.3.9074.18820 James.Green@deepdark.net James.Green@deepdark.net http://deepdark.net/Trackback.aspx?guid=e0d41aab-6f81-47ea-9681-7c7309bab953 http://deepdark.net/pingback.aspx http://deepdark.net/PermaLink,guid,e0d41aab-6f81-47ea-9681-7c7309bab953.aspx http://deepdark.net/CommentView,guid,e0d41aab-6f81-47ea-9681-7c7309bab953.aspx http://deepdark.net/SyndicationService.asmx/GetEntryCommentsRss?guid=e0d41aab-6f81-47ea-9681-7c7309bab953 1 Hows that for a long title? 

So there is a new version of Visual Studio (in CTP at time of writing) called Visual Studio Team Edition for Database Professionals - its aimed at people who might associate themselves with the title Database Professional.  I gotta say, it looks like a really good solution to some problems.

I attended a cabana session at Tech.Ed (Tech.James?) this year hosted by Greg Low on data generation in the product, and during the presentation it came up that it would be nice to have custom generator for Australian-specific data... so I thought I'd take a stab at it.

Below is a screencap of the kind of random data my generator will spit out.  Handy for columns where a check constraint may be forcing a given format for the data.  The format of the phone numbers is configurable by a property and the rows are conistant for a location so that if we generate a Vic address it will have a valid Vic phone number etc.



The good news is its really easy to do.  Even at this early stage the product has some pretty reasonable doco on what to do to write your own generators.

So my custom generator is available for download by clicking on this link

To install it on your copy of vsdbpro:

1. Copy the DLL from that zip into the following path on your PC: 
   [Program Files]\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\
2. Edit the config file at:
   [Program Files]\Microsoft Visual Studio 8\DBPro\Microsoft.VisualStudio.TeamSystem.Data.Extensions.xml with a suitable XML editor and add the following line:
   <type>deepdark.net.PersonalDetails, AustralianDetails, Version=1.0.0.0, Culture=neutral, PublicKeyToken=341d0bd35c6f7d28</type>
   
3. Restart Visual Studio, you should see a new generator called Personal Details in the list.
   

The source code is hardly going to start a revolutiuon, but I can make it available if there is any interest - just let me know.
http://deepdark.net/PermaLink,guid,e0d41aab-6f81-47ea-9681-7c7309bab953.aspx http://deepdark.net/PermaLink,guid,e0d41aab-6f81-47ea-9681-7c7309bab953.aspx Thu, 31 Aug 2006 23:16:57 GMT Hows that for a long title?&nbsp; <br> <br> So there is a new version of Visual Studio (in <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=4014554e-903a-4a62-b429-2b027321c32d&amp;DisplayLang=en">CTP at time of writing</a>) called <a href="http://msdn.microsoft.com/vstudio/teamsystem/dbpro/">Visual Studio Team Edition for Database Professionals</a> - its aimed at people who might associate themselves with the title Database Professional.&nbsp; I gotta say, it looks like a really good solution to some problems.<br> <br> I attended a cabana session at <a href="http://www.microsoft.com/australia/teched2006/">Tech.Ed (Tech.James?) this year</a> hosted by <a href="http://www.sqldownunder.com/">Greg Low</a> on data generation in the product, and during the presentation it came up that it would be nice to have custom generator for Australian-specific data... so I thought I'd take a stab at it.<br> <br> Below is a screencap of the kind of random data my generator will spit out.&nbsp; Handy for columns where a check constraint may be forcing a given format for the data.&nbsp; The format of the phone numbers is configurable by a property and the rows are conistant for a location so that if we generate a Vic address it will have a valid Vic phone number etc.<br> <br> <img src="http://deepdark.net/files/datagen.jpg"> <br> <br> The good news is its really easy to do.&nbsp; Even at this early stage the product has some pretty reasonable doco on what to do to write your own generators.<br> <br> <a href="http://deepdark.net/files/AustralianDetails_20060829.zip">So my custom generator is available for download by clicking on this link</a> <br> <br> To install it on your copy of vsdbpro: <br> <ol> <li> Copy the DLL from that zip into the following path on your PC:&nbsp;<br> <font face="Courier New" color=#000000>[Program Files]\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\</font> <li> Edit the config file at: <br> <font face="Courier New" color=#000000>[Program Files]\Microsoft Visual Studio 8\DBPro\Microsoft.VisualStudio.TeamSystem.Data.Extensions.xml</font> with a suitable XML editor and add the following line: <br> <font face="Courier New" color=#000000>&lt;type&gt;deepdark.net.PersonalDetails, AustralianDetails, Version=1.0.0.0, Culture=neutral, PublicKeyToken=341d0bd35c6f7d28&lt;/type&gt;</font> <br> <li> Restart Visual Studio, you should see a new generator called Personal Details in the list.<br> </li> </ol> <br> The source code is hardly going to start a revolutiuon, but I can make it available if there is any interest - just let me know.<br> http://deepdark.net/CommentView,guid,e0d41aab-6f81-47ea-9681-7c7309bab953.aspx Database Downloads Geeking Out! Australian Data Generator for DB Pros