I would like to receive suggestions on the data generators that are available, for SQL server. If posting a response, please provide any features that you think are important. I have never used a application like this, so I am looking to be educated on the topic. Thank you. (My goal is to fill a database with 10,000+ records in each t...
When I attempt to run the data generation plan I get the following error, but there are no columns to be deleted. The column XXXXX has been deleted and was previously selected for data generation. Any help on this error would be appreciated. Thanks ...
In python, I need to generate a dict that maps a letter to a pre-defined "one-hot" representation of that letter. By way of illustration, the dict should look like this: { 'A': '1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 'B': '0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', # ... } There is one bit (represented as a...
I'm just getting started with Visual Studio Database projects and loving the data generation plans I can create with it. However, in one of my projects I need to populate a lookup table with specific values. Since a foreign-key relationship exists between the lookup table and another table, I can't remove the lookup table from the data g...
I have an Oracle 10g database with about 11,000,000 rows of data. It's good for our usually performance tests, but I now have to test our app for a customer that will have an estimated 350,000,000 rows of data. Is there a tool or technique that I can use to "bulk up" the tables in my database to this size? Ideally, I'd like to use the e...
Is it possible to have 2 fields with the same data for a Data Generation Plan? For example, the table aspnet_roles has 2 fields RoleName and LoweredRoleName and I want them to show the same data. ...
I'm looking for a tool that will let me generate a data set with certain statistical properties. For example, suppose I want to generate 1 million integers with x number of outliers for use in testing. Are there any tools for generating test data sets like this? I don't necessarily need anything fancy, just some basic functionality. ...
Using the Visual Studio Data Generation Plan, I have two columns, FirstName and Lastname, populated from a Data Bound Generator (referencing a database seeded with actual valid First and Last Names). I want to generate another column for email with the format @test.com. For example: Fred, Smith => [email protected] Right now I am us...
I followed the instructions in this document: http://msdn.microsoft.com/en-us/library/bb386244.aspx And in the final step nothing appears as a choice in the "Generator Output" dropdown. (Ultimately, I want a file of sample data that I can check in with my Visual Studio Database project so all developers get the same data and thus gene...
I have an Entity Framework model using Table per Type Inheritance, but when I use a VS Data Generation Plan it produces duplicate keys in the child tables, which is a problem for EF. Does anyone know of a way to get this to work, so that the child tables do not have overlapping keys? ...
I need to populate a currently empty table with a hundred or so fake records to simulate logins over the past two years to test my code with. The login table schema looks like: CREATE TABLE `Logins` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `User_ID` int(11) NOT NULL, `Date_Login` datetime NOT NULL, `Location` enum('site','admin'...
Given a regexp, I would like to generate random data x number of time to test something. e.g. >>> print generate_date('\d{2,3}') 13 >>> print generate_date('\d{2,3}') 422 Of course the objective is to do something a bit more complicated than that such as phone numbers and email addresses. Does something like this exists? If it does,...
I'm wondering if there is a good option for those of us using Express (or even Professional) editions without having to go outside the Visual Studio project (i.e. writing a ruby/perl/etc script to populate test/seed data). If it helps I'm working on a C# .NET MVC 2 app within MS Web Developer 2010. ...
The data generation tool that comes with Visual Studio allows you to populate tables with random/patterned data. As an example, you can tell it to populate an Employees table with 50,000 rows and you can tell it to add 5 address rows to an Addresses table for each Employee row. I've got a junction table much like the permissions exampl...
Has anyone every heard of a program which analyses a satellite map and attempts to generate three dimensional buildings that roughly match the length/width of their real life counterparts? The use in programs like Google Earth would be phenomenal, and it would be particularly amazing for projects like FlightGear. I'm just about to star...