This release of Bulk Data Generator extension for Visual studio is compatible with 2017, 2019, 2022 community and professional versions. Bulk Data Generator provides a convenient way for generating bulk data for SQL Server. It can generate record either for table or for stored procedure, in both cases user will get three different ways to export the data.
Direct update -> This way user can update the target table with data
Clipboard -> Generated insert scripts will be stored in the clipboard and can be pasted to SSMS query window for further execution.
Notepad -> Generated insert script will be opened in the notepad and user can save the file later.
Preview
Features
You can generate data either for table or stored procedure
Insert script can be executed directly from tool itself
Insert script can be stored as sql file and shared to others
Generated insert script can be captured on clipboard user can paste to their preferred location
Tool supports many data types as predefine.
Installation
In Visual Studio 2109, select menu item Extensions > Manage Extensions.
In the tree view, select the Online node.
In the Search text box, type "Bulk Data Generator” and then press ENTER.
In the Bulk Data Generator tile, select Download.
You can download the VSIX file and install offline.
How to use this tool
Follow the installation steps and install the tool first
Open the tool from View Menu -> Other Windows -> Ranjan's - Bulk Record Generator
Dock the tool in a way like it can utilize all the coding space in visual studio and running as a tab
A default connection string is already written, just alter as per your requirement.
Now click on Table or Stored procedure (if you wish to insert record in table directly choose table, or in case you want to use stored procedure to insert the data choose Stored procedure)
Now select the proper DB Object from drop down (Don't uncheck the check box Table if you are using table db objects.
You can remove identity column (Because generated scripts will not populate additional command for Identity off insert)
You can remove Null column - (Sometimes we need record generation that doesn't depend on Null columns, in that case you can remove these columns)
Now click on Populate button (Populate button will generate data in right side grid)
Now you need to customize each column one by one. Choose respective data types (there are 20 data types support available)
Click on Number of records drop down menu (Range varies from 5 to 50K records)
Select export type (There are three export types available, described in overview section)
Now click on Generate button to generate the records.
User can click on Save to save this configuration (Left side configurations are not saved like, Connection string, number of records, export type, etc.)
To load existing saved configuration user needs to click on Load button. (After loading a configuration, choose connection string carefully)
Data types supported
AlphaNumeric : ALPHANUMERIC-{10}
AutoIncrement : AUTOINCREMENT-{1}
City : ALPHABETS-{10}
CityName : ALPHABETS-{10}
Company : ALPHABETS-{10}
Country : ALPHABETS-{10}
CountryName : ALPHABETS-{10}
CreditCardNumber : NUMBER-{16}
Currency : NUMBER-{3}
Cvv : NUMBER-{3}
Date : 30 Days before and after
Email : No Customization(Will be populated automatically)
Fixed : Any value
FixedQuote : Any value with single quotes
Guid : GUID Value
Names : FIRSTNAME LASTNAME
PersonalNumber : NUMBER-{9}
Phone : NUMBER-{10}
Pin : NUMBER-{4}
Zipcode : NUMBER-{5}
Installation of the tool in Sql Server Management Studio (V18.0 Onwards Supported)
Download the VSIX file from Market place
Rename the VSIX file to Zip (Windows operating system will ask for confirmation, click yes)
Now extract the files in a folder name "BulkDataGenerator" using any zip tool or windows explorer.
Now copy the entire folder "BulkDataGenerator" to this location C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions
In case Sql Server Management Studio is running, restart the application (Don't forget to save your work)
Follow the instructions mentioned in the section How to use this tool from step number 2.
