Home
  Home
Home
Search
Articles
Page Tag-Cloud
  Software
Software Tag-Cloud
Building from Source
Open Source Definition
All Software
  Popular Tags
C Plus Plus
Source Code
Legacy
Class
Networking
  Members
Login
Web-Email
Notable Members
  Official
Our Company
Copyright Information
Software EULA
GPL EULA
LGPL Eula
Pre-Release EULA
Privacy Policy
  Support
Make Contact
 
DataRandomizer SQLCLR
Downloads   208
User Rating         (Rate)
Last Updated   12/18/2018
License   Apache License
- Download -
View all Releases
Recommended Release
Version   1.0.0.2
Date   12/18/2018
Status   Stable Stable software is believed to be stable and ready for production use.

This software is open source. You can obtain the latest source code from the GitHub repository or browse the releases for the source code associated with a specific release. If you make any changes which you feel improves this application, please let us know via our Contact Page.

If you’ve ever needed to generate random data inside SQL server then you probably know what a pain it can be, especially when you need that data to be human readable cities, states, names, phone numbers, etc.

This CLR make the task quick, easy and performs very well! The download contains the CLR DLL, install script, example script and also a great deal of pre-generated word lists.

Please keep in mind that this CLR was designed for development and test environments and is not at all intended for production use.

Install steps:

  • On the SQL Server, unzip to C:\
  • Run script: C:\CLR\DataRandomizer\Install Functions.sql
  • Of course, you can change the location if you also alter the script.
  • Enjoy.

Example SQL Script:

SELECT
    dbo.IsInitialized() as IsInitialized,
	dbo.FlipCoin() as FlipCoin

SELECT
	dbo.GetRandomString(10) as GetRandomString,
	dbo.GetRandomAlphaString(10) as GetRandomAlphaString,
	dbo.GetRandomNumberString(10) as GetRandomNumberString

SELECT
	dbo.GetRandomStringLengthBetween(5, 10) as GetRandomStringLengthBetween,
   	dbo.GetRandomAlphaStringLengthBetween(5, 10) as GetRandomAlphaStringLengthBetween,
	dbo.GetRandomNumberStringLengthBetween(5, 10) as GetRandomNumberStringLengthBetween

SELECT
	dbo.GetRandomFullAddress() as GetRandomFullAddress,
	dbo.GetRandomStreetAddress() as GetRandomStreetAddress,
	dbo.GetRandomPhoneNumber() as GetRandomPhoneNumber,
	dbo.GetRandomNumberOfWords(2, 5) as GetRandomNumberOfWords,
	dbo.GetRandomCompanyName() as GetRandomCompanyName

SELECT
	dbo.GetRandomWords(3) as GetRandomWords,
	dbo.GetRandomCity() as GetRandomCity,
	dbo.GetRandomStreetSuffix() as GetRandomStreetSuffix,
	dbo.GetRandomWord() as GetRandomWord,
	dbo.GetRandomStreetName() as GetRandomStreetName

SELECT
	dbo.GetRandomDomainSuffix() as GetRandomDomainSuffix,
	dbo.GetRandomStateName() as GetRandomStateName,
	dbo.GetRandomEmailAddress() as GetRandomEmailAddress,
	dbo.GetRandomNumber(10, 20) as GetRandomNumber,
	dbo.GetRandomCounty() as GetRandomCounty

Results:
Data Randomizer Results.png

Recent Releases:
 1.0.0.2    1.0.0.1    1.0.0.0  

Tags:
 C-Sharp    CLR    Data    Database    SQL Server  

No comments currently exists for this software. Why don't you add one?
First Previous Next Last 

 
Copyright © 2024 NetworkDLS.
All rights reserved.
 
Privacy Policy | Our Company | Contact