Ways to generate database test data

First, SQL Server

1. Microsoft Visual Studio is able to generate data from Microsoft's own son, SQL Server.

For more information, see: vs Data generation

2. Using the tools provided by Redgate: Sql-data-generator

Second, ORACLE

1. Use the Generate function of PL/SQL.

For more information: Oracle Data Generation Instructions

Third, MySQL

1. Access the password using SQL ASSISTANT,:HTTPS://YUNPAN.CN/CRW9FXBJ3WFBI e48c

Iv. General Methods

1. It's OK to write your own script.

2. SQL Assistant can connect all databases to generate data, strong, recommended.

Five, meaningful fields

I found a tool that can generate meaningful fields, see: Http://git.oschina.net/codingox/Faker.Net, I fork it to open source China.

Ways to generate database test data