Step 3: Apply for a free data source and generate test data
This article describes how to apply for a free data source (Demo data source) and generate test data.
Description
NineData provides two free MySQL test data sources for each user and organization. Before officially adding the enterprise database to NineData, user can apply for free data sources for functional testing purposes.
The Employees Sample Database database officially provided by MySQL is automatically generated in the free data source. For more information about this database, please refer to the official documentation .
Restrictions
- Free data can be used for 3 months from the date of application, and it will be automatically deleted when expires.
- Free data sources have a storage size limit of 1 GB, beyond which the data become read-only.
- The free data source is only for NineData functional testing, please do not use it for other purposes.
- Each user (Personal modeAfter registering a NineData account, you are usually in personal mode by default. In this mode, you can easily use the four major functions provided by NineData, which is suitable for individual developers, such as backup, recovery, synchronization, comparison of their own databases, and daily development work with SQL Console.) or organization (Organization modeOrganization mode supports assigning different roles and resource management permissions to each user under the organization, which is suitable for multi-user collaborative development under the same organization, while ensuring data security and improving overall production efficiency.) can request up to 2 free data sources.
- The free data source does not support automatic database creation. For purpose as a data recovery target or data replication target, user need to manually create a database with the same name as the database to be recovered in the SQL console before test. Otherwise, an error message will show up as No DDL permission during pre-check.
Steps
In the left navigation bar of the NineData console, click Datasource > Datasource , and click Apply Demo in the upper right corner of the page .
tipNewly registered users can also click Apply for Free Datasource to apply for a free data source on the Home page after logging in. This entry is only displayed if no data sources have been added under the current user or organization.
On the Apply for Free Datasources page, select the number of data sources under the Application Qty. to apply data sources, up to 2.
Click Apply Demo to complete the application for a free data source, and jump to the SQL Console page of the data source. At this point, the system starts to import the test data set. This process will last about 30 seconds. After the import is completed, the SQL Console will prompt that the Demo dataset imported successfully! .
tipUser can also manually import the test dataset by clicking Import Demo Dataset in the upper right corner of SQL Console page and clicking OK.