Home

Data Generator for MySQL

1. n results in iteration of the last sign n times the character after the symbol is interpreted as a common character All the rest of the mask characters will be moved to the result value without changes ER Masks Name Value Mask1_website http Awww a 10 com Mask2_website http hwww a 8 a 3 org Mask3_email a 8 aqmail com Mask4_vehicleidnumber a 2 N 4 a 3 Mask5_address a 6 Str N 2 Generate incremental data Specify the Initial value and the Increment properties to generate an ordered incremented sequence of values 2012 EMS Database Management Solutions 47 Data Generator for MySQL User s Manual Data generation mode Generate random data Get data from list SQL query Get data from Field Parameters Inital value a Increment 1 Start char a 97 D End char z 122 D Charset asci ASCII mM Get data from list SQL query This panel allows you to define the list of values to generate string data from You can enter these values directly into the editor by selecting the List of Values option To add a single value use the E Add Value button o To load a list of values from an existing external file use the B Load from file button To save the list to an external file use the b Save to file button To remove a single value use the Delete Value button To remove all items from the list use the E Clear button You can also specify wheth
2. cceeecececeeeseeeeeeeeeeeeeeeseeeeeeeseeeeeeeseeeeeeeseeeeeeeseeeeeeeseeeeeeeneeeseees 97 Part IV Appendix 99 SSH tunneling e TE 99 HTTP tunneling Options scenerne ee eeeeaeeeeeeeeeseeeseeeseeeseeeeeeeeeeneeeesees 100 Data generation mode ee EEEERRRR KEE RRRR KEE eeeeeeeeeeeeeeeeseeeaeeeseseeeeeseseeeseeeseeeseeesseeeeeeeees 101 Configuration file format ccceeeeece cece ee ee ee EE RRE EE RRE EE RRE EE eeeeee se ERER EE ERER EE nnmnnn nnmnnn 102 Find Text dial Og WEE 105 Replace Text dialog sisicccceccccckiesnscesicecescecen SSC SEE EES REES EES EE Sg 107 2012 EMS Database Management Solutions 6 Data Generator for MySQL User s Manual 1 Welcome to EMS Data Generator EMS Data Generator for MySQL is a powerful utility for generating test data into one or several MySQL database tables simultaneously with script saving and editing capabilities The wizard application allows you to define tables and fields for generating data set value ranges generate string fields by mask load values for BLOB fields directly from files set lists of values manually get sets of values from SQL queries and perform other operations with test date in a simple and direct way The distribution of the utility also provides you with the console application which allows you to generate data in one touch by using data generation templates Visit our web site http www sqimanager net for details Key features e Unicode su
3. 7 Random order el B be se LEGAL DEPARTMENT ACCOUNTING DEPARTMENT I ADMINISTRATIVE DIVISION nn Je 2012 EMS Database Management Solutions 57 Data Generator for MySQL User s Manual 2 1 4 1 9 BIT field parameters Bit strings are strings of 1 s and O s They can be used to store or visualize bit masks You can generate values for this field randomly incrementally or choose to take them froma specified list of values or SQL query or from an existing table field of the same data type The Generation properties panel allows you to define preferences for generating values for Bit field type IsActive bit 1 Bit strings are strings of 1 s and O s They can be used to store or visualize bit masks Set NULL value in 10 ofcases Select Data generation mode as follows Generate random data Specify the ratio between True and False values in randomly generated data Data generation mode Generate random data Generate incremental data Get data from list SQL query Get data from Field Parameters 0 25 1 75 Generate incremental data Specify the Initial value and the Increment properties to generate an ordered incremented sequence of values The value is incremented bit by bit 2012 EMS Database Management Solutions 58 Data Generator for MySQL User s Manual Data generation mode Generate random data Generate incremental d
4. 35 Data Generator for MySQL User s Manual Data generation mode Generate random data Generate incremental data 9 Get data from list SQL query Get data from Field Parameters List of Values 5 SQL query 7 Random order B B 0 H e 1 Get data from Field This option allows you to specify a field to generate data from use the Table and Field drop down lists to select the source table and field that will be used to take data for generation Data generation mode Generate random data Table ORDER D Field eeng D 2012 EMS Database Management Solutions 36 Data Generator for MySQL User s Manual 2 1 4 1 2 FLOAT field parameters Float fields are used for approximate numeric data storage Values for this field can be generated randomly incrementally or they can be taken from a fixed list of values or SQL query or from an existing table field of the same data type The Generation properties panel allows you to define preferences for generating values for floating point numeric field types SALARY double 15 3 Float fields are used to hold approximate numeric data Values for this field can be generated randomly incremental or taken from fixed list of values Set NULL value in 10 of cases Select Data generation mode as follows Generate random data Here you can define the number of digits and the precision for the r
5. SQL Manager 7 EMS Database Management Solutions a m Data Generator for MySQL User s Manual 2012 EMS Database Management Solutions Data Generator for MySQL User s Manual 2012 EMS Database Management Solutions All rights reserved This manual documents EMS Data Generator for MySQL version 3 0 x x No parts of this work may be reproduced in any form or by any means graphic electronic or mechanical including photocopying recording taping or information storage and retrieval systems without the written permission of the publisher Products that are referred to in this document may be either trademarks and or registered trademarks of the respective owners The publisher and the author make no claim to these trademarks While every precaution has been taken in the preparation of this document the publisher and the author assume no responsibility for errors or omissions or for damages resulting from the use of information contained in this document or from the use of programs and source code that may accompany it In no event shall the publisher and the author be liable for anyloss of profit or any other commercial damage caused or alleged to have been caused directly or indirectly by this document Use of this documentation is subject to the following terms you may create a printed copy of this documentation solely for your own personal use Conversion to other formats is allowed as long as the actual conte
6. lt path to Data Generator for MySQL console application gt MyDataGenC exe TemplateFile L B TemplateFile Stands for the gtm template file to be used as the console version execution parameter L Applies the current localization selected in Wizard Application GUI B Use this parameter in the command line to run the console version of Data Generator for MySQL in background mode Example C Program Files EMS Data Generator for MySQL MyDataGenC exe C EMS Templates DataGenerator Example gtm L Note The result of the latest task performed by Data Generator for MySQL can be found in the system variable ERRORLEVEL 0 successful completion 1 error s occurred during task performing 2 fatal error occurred The task was not performed See also Using wizard application Configuration file format 2012 EMS Database Management Solutions 99 Data Generator for MySQL User s Manual 4 Appendix 4 1 SSH tunneling options To setup the connection via SSH tunnel input the following values in the corresponding fields e SSH host name is the name of the host where SSH server is running e SSH port indicates the port where SSH server is activated e SSH user name stands for the user on the machine where SSH server is running Note it is a Linux Windows user not a user of MySQL server e SSH password is the Linux Windows user password Please note that MySQL host name should be set rela
7. Text to replace Wilkam D Options Direction Case sensitive E Whole words only Forward Regular expressions Backward Prompt on replace Scope EE Global From cursor Selected text Entire scope Mark search result with stack marker oc sce es C Direction Forward Searches and replaces from the current position to the end of the working area Backward Searches and replaces from the current position to the beginning of the working area Scope Global Searches and replaces within the entire working area in the direction specified by the Direction setting Selected text Searches and replaces only within the currently selected text in the direction specified by the Direction setting You can use the mouse or block commands to select a block of text Origin From cursor The search and replace process starts at the cursor s current position and then proceeds either forward to the end of the scope or backward to the beginning of the scope depending on the Direction setting Entire scope The search and replace process covers either the entire block of selected text or the entire script no matter where the cursor is in the Editor area depending upon the Scope 2012 EMS Database Management Solutions 109 Data Generator for MySQL User s Manual options W Mark search result with stack marker The option toggles marking search results If this opt
8. features to generate test data in a simple and direct way The utility also provides you with the console application which allows you to generate data in one touch by using generation templates What do I need to start working with EMS Data Generator for MySQL First of all you must have a possibility to connect to some local or remote MySQL server to work with Data Generator for MySQL You can use the following link to download the server http www mysgl org downloads Besides you need your computer to satisfy the system requirements for Data Generator for MySQL What is the easiest way to configure the template files for the console application of Data Generator A You can configure the template files for each table or export type visually using the gt O gt O MySQL Data Generator wizard Set the required generation options at Step 4 of the wizard click the Tools button and select the Save Template popup menu item All the options will be saved to the template file which can be used later in the console application How can I register the product If you have already purchased Data Generator for MySQL you can register the product by entering the appropriate registration information Please refer to Registration and How to register EMS Data Generator for details Are there any limitations implied in the trial version as compared with the full one The trial version of the utility admits to the maximum
9. server are allowed This script exposes the MySQL API as a set of web services used by Data Generator for MySQL In case of using this connection method the response will be slower as compared to the direct connection or the SSH Tunneling method since the data are XML encoded and HTTP is stateless by nature However all the features of Data Generator for MySQL are available Note that the emsproxy php script file is included into the distribution package and can be found in Data Generator installation directory 2012 EMS Database Management Solutions 101 Data Generator for MySQL User s Manual 4 3 Data generation mode This option defines data generation mode random data generation incremented values generation or getting data from list or SQL query or getting data from an existing table field Select the Generate random data option to generate random data within the defined range Another mode Generate incremental data allows one to set the initial value and the increment for generated values Select the Get Data from List SQL query option to generate data by getting values from the user defined list randomly or in the fixed order This can be a list of values for numeric string date time boolean data types a list of files for BLOB data type an SQL query previously defined sample text for string data types Select the Get data from Field option to specify a field to
10. style regardless of other painting settings Note The Native style option is currently supported for the Windows XP operating system only See also Trees and lists Edit controls Buttons Page controls Group boxes Fonts 2012 EMS Database Management Solutions 87 Data Generator for MySQL User s Manual 2 3 4 4 Buttons Use the Buttons section to customize Data Generator buttons Button kind i Ultrafiat Trees and lists EI Edit controls V Native style M Check boxes ie Button kind This setting determines the manner in which a button is painted Use the drop down list to select the painting style that will be applied to buttons Standard Flat UltraFlat Native style This option determines whether the native Windows style will be applied to the buttons The option has a higher priority than the Button kind setting If this option is selected the buttons are painted according to the native Windows style otherwise the Button kind selection is applied Note The Native style option is currently supported for the Windows XP operating system only See also 2012 EMS Database Management Solutions 88 Data Generator for MySQL User s Manual Trees and lists Edit controls Check boxes Page controls Group boxes Fonts 2012 EMS Database Management Solutions 89 Data Generator for MySQL User s Manual 2 3 4 5 P
11. BIT field parameters View le table RE Data Preview anropar dg E EES Step 4 Setting generation options ssccssecseessesseessesseesersneesseseneerseeesnesseeesseseceseneneeeseeseerseeseessneeseesenenseens Step 5 Start of data generation Process us senrnsnsnnnnrnrnnnnnnrnnnnnnrnnnnnnnnnnnennnnnn en Step 6 Editing generation script ceeseeesseeseesseeseeeseeeseesenseeeenesseseneeeneneneneee Using configuration files ccccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeseeeeneeseeeseees Saving Configuration file eseeeeEESEESEESEENEEREEREEREEEEEEREEREEREEREEREEREEEEEREEEEEREEEEEESEESEESEENEN Save Template Options re RE ENEN A ETRE ET Loading Configuration file cs cssecsseseeseecseesseeeseeseeeeseenenesseeneneneeeseeeseeeseeseeesenees Setting program preferences EEN REENEN ENEE Setting general Options ege Setting default constraints ceecceeeeeeeeeeeeeeeeeeeeeeeseeeesneeeseeeeneeeeeseeeseeeenseeeeeneeees Setting program language ninaa aeara eiaa eaaa anaa aaraa ria aea Defining interface Style oo ecstsesseeeesesseeseeseeseesoesessesessevenvsneseeneeseesnesaesaesoneaes RG TEE See e EE CHECK e10 ETAETA ERTE ETETETT EE 2012 EMS Database Management Solutions A Data Generator for MySQL User s Manual Lei De 87 Paige Controls EE 89 Gro p BEE 91 Eppes Deeg ERE EE Eed dE EES 93 Part Ill Console Application 96 Using Console application
12. J g Le Ce H lt Beck When you select a table in the Generate data for tree you can set data generation parameters for each of its fields within the Generation properties area at the right side of the window Use the and the buttons to manage fields within the Field list area For each field you can set the following 2012 EMS Database Management Solutions 32 Data Generator for MySQL User s Manual W Set NULL value in of cases Check this option and specify the percentage of NULL values for the field if necessary Other generation parameters vary according to the data type of the selected field e FLOAT field parameters e INTEGER field parameters e DATE field parameters e TIME field parameters e STRING field parameters e BLOB field parameters e GEOMETRIC field parameters e ENUM and SET field parameters e BIT field parameters If a field is part of a foreign key you can select one of the following options for this field Generate data from the dependent field Values for the field will be taken from the corresponding field s of the foreign table s Generate data from list SQL query Ratio 1 N If this option is selected you should specify the N value using the spin edit box below Data will be generated into the field related as 1 N i e n records will be generated into the foreign table for each record of the primary table Data generation mode Generate data from the depe
13. Management Studio for PostgreSQL EMS SQL Management Studio for PostgreSQL is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SOL Manager for PostgreSQL Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways 2012 EMS Database Management Solutions 19 Data Generator for MySQL User s Manual Data Export for PostgreSQL Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for PostgreSQL Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for PostgreSQL Migrate from most popular databases MySQL SQL Server Oracle DB2 InterBase Firebird etc to PostgreSQL Data Generator for PostgreSQL Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters DB Comparer for PostgreSQL Compare and synchronize the structure of your databases Move changes on your development database to production with ease S e di a DB Extract for PostgreSQL Create database backups in the form of SQL scripts save your d
14. Minimize button to minimize the application to Windows Task bar or the Cancel button to stop the generation process During data generation the Generation Log area displays the log of performed operations and errors if any When the process is completed you can use the View SQL file in editor and the Save log to file buttons to edit the data generation script at Step 6 of the wizard and save the generation log content to an external text file respectively Do not forget to save data generation options if you need to repeat the generation process with the same or similar settings later 2012 EMS Database Management Solutions 66 Data Generator for MySQL User s Manual 2 1 7 Step 6 Editing generation script This step of the wizard allows you is provided for working with the result SQL script for data generation For your convenience the code folding syntax highlight and a number of other features for efficient SQL editing are implemented e E Data Generator for MySQL Lal ke Step 6 of 6 Click the Save button to save change in SQL script Er Generating data for database test E sl Generating data for table orders H A INSERT INTO brders order id user id vendor id order number user info id VALUES 101 Markers 1719599838 1708642991 HINSERT INTO Rer iIndor W order number user info id VALU
15. SQL Query option and input an SQL query into the editor and the resulting dataset will be used as the list for data generation 2012 EMS Database Management Solutions 41 Data Generator for MySQL User s Manual Data generation mode Generate random data Generate incremental data Get data from list SQL query Get data from Field 02 11 2012 03 11 2012 04 11 2012 E 05 11 2012 l 06 11 2012 Get data from Field This option allows you to specify a field to generate data from use the Table and Field drop down lists to select the source table and field that will be used to take data for generation Data generation mode Generate random data Generate incremental data Get data from list SQL query Get data from Field Parameters Table ORDER Field SALE DATE 2012 EMS Database Management Solutions 42 Data Generator for MySQL User s Manual 2 1 4 1 4 TIME field parameters Time fields are used for temporal values storage Values for this field can be generated randomly incrementally or they can be taken from a fixed list of values or SQL query or from an existing table field of the same data type The Generation properties panel allows you to define preferences for generating time values for time field types LoginTime time The time fields are used for holding temporal values Values for this field can be
16. database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SQL Manager for DB2 Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for DB2 Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for DB2 Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for DB2 Migrate from most popular databases MySQL PostgreSQL Oracle MySQL InterBase Firebird etc to DB2 Data Generator for DB2 Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters DB Comparer for DB2 Compare and synchronize the structure of your databases Move changes on your development database to production with ease DB Extract for DB2 Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for DB2 Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more Data Comparer for DB2 Compare and synchronize the c
17. of 100 records to be generated at a time In all other respects it does not differ from the full version as far as the functionality is concerned That is you can test all the features implemented in Data Generator for MySQL within the 30 day trial period 2012 EMS Database Management Solutions 16 Data Generator for MySQL User s Manual Scroll to top If you have any additional questions contact us at our Support Center 2012 EMS Database Management Solutions 17 Data Generator for MySQL User s Manual 1 8 Other EMS Products Quick navigation YS E BR o RW e MySQL Microsoft SQL PostgreSQL InterBase Oracle IBM DB2 Tools amp MySQL SS T e dd B ei SW S FireBird components SQL Management Studio for MySQL EMS SQL Management Studio for MySQL is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SQL Manager for MySQL Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for MySQL Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for MySQL Import your data from MS Acc
18. processing of table relationships Minor interface improvements Fixed the bug when ordering tables related Version 2 0 e Completely rewritten source code e More user friendly wizard interface e Retrieving values for data from SQL queries Wizard interface has become more user friendly Implemented Private Key support for SSH authentication Added the Clear tables before generation option Improved data generation for tables with Foreign keys Added the ability to load lists of values from TXT and CSV files Fixed a bug concerned with applying default constraints HTTP tunnel SSH tunnel Now you can generate incremental data for date fields Formula based random data generation for integer fields by foreign keys Fixed the bug concerned with refreshing metadata Fixed the bug concerned with generation of NULL values Release date February 7 2007 June 26 2006 August 8 2005 April 12 2005 May 14 2003 roducts mysql Scroll to top Scroll to top Scroll to top 2012 EMS Database Management Solutions 14 Data Generator for MySQL User s Manual Foreign keys support The opportunity to empty tables before data generation The ability to set NULL values for certain percent of cases String fields data generation by mask Incremental data generation for float fields Getting values for BLOB fields from files A number of bugs fixed Scroll to top Version 1 0 Basic features e Generating dat
19. the application wizard if you need to make some changes before data generation or you can run it with the console application for quicker generation e Saving configuration file e Loading configuration file See also Using wizard application Setting program preferences 2012 EMS Database Management Solutions 69 Data Generator for MySQL User s Manual 2 2 1 Saving configuration file Data Generator templates are saved within the Save template options dialog To open this dialog press the Tools button and select the Save Template popup menu item kd Save Template KO Load Template d Preferences Reopen Template gt Please note that you can only save data generation options at the Specifying generation parameters step or at the last step of Data Generator for MySQL wizard e Save Template options e Loading configuration file 2012 EMS Database Management Solutions 70 Data Generator for MySQL User s Manual 2 2 1 1 Save Template options File name Specify the template file name and select its location using the button to open the Save As dialog Comment If necessary set a comment for your template file in this field File name C EMS Templates mydatagen gtm Comment Test data generation a Cancel Help 2012 EMS Database Management Solutions 71 Data Generator for MySQL User s Manual 2 2 2 Loading co
20. the path to the sq file to store the SQL script 2012 EMS Database Management Solutions 64 Data Generator for MySQL User s Manual 2 1 6 Step 5 Start of data generation process This step informs you that all data generation parameters are set and you can start the generation process Step 5 of 6 Click the Generate button to start data generation process Generating data for database test Generating data for table orders Generation started Generation complete 100 records generated 0 errors occurred Generating data for table customers Generation started Generation complete 100 records generated 0 errors occurred View SQL file in editor Save log to file If everything is correct press the Generate button to start the process If you want to change something you can return to any of the wizard steps using the Back button The Generating dialog indicates the amount of generated records elapsed time the number of errors if any and visually represents the percentage of data generated 2012 EMS Database Management Solutions 65 Data Generator for MySQL User s Manual f Generating Ea TableName customers Records 34 Errors 0 Speed 0 Elapsed Time 0 00 04 Data Generated Send to Background Minimize Use the Send to background button to run the process in the background mode the
21. ways Data Export for Oracle Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for Oracle Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for Oracle Migrate from most popular databases MySQL PostgreSQL MySQL DB2 InterBase Firebird etc to Oracle Data Generator for Oracle Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters DB Comparer for Oracle Compare and synchronize the structure of your databases Move changes on your development database to production with ease S e A a 2012 EMS Database Management Solutions EA Data Generator for MySQL User s Manual E d SW DB2 aden dad B AS DB Extract for Oracle Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for Oracle Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more Data Comparer for Oracle Compare and synchronize the contents of your databases Automate your data migrations from development to production database Scroll to top SQL Management Studio for DB2 EMS SQL Management Studio for DB2 is a complete solution for
22. 1 Trees and lists Use the Trees and lists section to view and edit the corresponding options Look amp feel This setting determines the manner in which tree and list elements are painted Use the drop down list to select the painting style that will be applied to the trees and lists Standard Flat UltraFlat Hide selection This option specifies how selected tree nodes and list items are displayed when focus leaves the tree or list control If this option is enabled selected nodes look like other nodes Otherwise selected nodes items are highlighted within the tree list Hide focus rectangle This option determines whether a focus rectangle is displayed around the focused tree node or list item within the tree or list control If this option is disabled the focused node item is not highlighted but the focus rectangle is displayed around it 2012 EMS Database Management Solutions 82 Data Generator for MySQL User s Manual W Native style This option determines whether the native Windows style will be applied to the trees and lists The option has the highest priority for trees and lists If this option is selected the tree nodes and list items are painted according to the native Windows style regardless of other painting settings Note The Native style option is currently supported for the Windows XP operating system only See also Edit controls Check b
23. 2012 EMS Database Management Solutions 25 Data Generator for MySQL User s Manual 2 1 Using wizard application Go through the steps of the wizard and follow the wizard instructions to generate test data for your needs e Getting started e Step 1 Setting connection properties e Step 2 Selecting databases and tables e Step 3 Specifying generation parameters e Step 4 Setting generation options e Step 5 Start of data generation process e Step 6 Editing generation script See also Using console application 2012 EMS Database Management Solutions 26 Data Generator for MySQL User s Manual 2 1 1 Getting started This is how Data Generator for MySQL wizard application looks when you first start it This page allows you to view registration information If you have not registered Data Generator for MySQL yet you can do it by pressing the Enter Registration Code button and specifying your registration information EB Data Generator for MySQL sec Welcome to Data Generator for MySQL Wizard This Wizard allows you to generate random data of any type for MySQL database tables Click Next to start working with the wizard Product Information Developers Dmitry Schastivtsev Alexander Zhitsov Alexey Butalov Sergey Sviridov Homepage http www sqimanager net products mysaql datagenerator Support Ticket System http www sqimanager net support Version 3 0 1 3
24. 9 09 17 50 41 000004 2012 1 86 1354 11 EMS 2010 10 20 07 34 35 000007 2012 1 87 1563 63 DHL 2011 04 12 23 28 33 000004 2012 1 88 2163 31 UPS 2012 03 10 12 31 21 000005 2012 1 89 1551 54 Emery 2012 09 03 08 17 17 000006 2012 1 90 3054 5 DHL 2010 10 20 12 20 34 000008 2012 1 91 5412 4 UPS 2010 12 03 00 40 13 000005 2012 1 92 6516 24 EMS 2011 06 05 17 47 09 000004 2012 1 93 4531 38 UPS 2012 02 28 21 46 04 000007 2012 1 E 94 2156 99 Emery 2010 09 01 13 39 51 000005 2012 1 3 95 4531 74 UPS 2011 03 19 19 10 13 000004 2012 1 4 w p ep If necessary you can filter records in the grid in either of the following ways e click the Arrow Down button next to the column caption to display the drop down list and select any of the column values to filter records by this value of the selected column e click the Arrow Down button next to the column caption to display the drop down list then select the Custom item and build a simple filter using the Custom Filter dialog Select a logical operator for checking the column values like is less than is greater than etc and set a value to be checked by this operator in the corresponding box on the right 2012 EMS Database Management Solutions 62 Data Generator for MySQL User s Manual Custom Filter Show rows where ADDRESS ID ke MM AND DOR el Use _ to represent any single character Use to represent any series of characters oa
25. ES 102 x H INSERT INTO GotoLineNumber Inder NM order number user info id VALUES 103 kay Undo B N nA6Pi FH70f c Ro 1637378766 E INSERT INTO Indor id order number user info id VALUES 104 q Redo Nd lt pm 1896038266 1569461504 E INSERT INTO Cut indor_id order number user info id VALUES 105 8 c 7 498703627 EIINSERT INTO 4 Ka Copy Inder JK order number user info id VALUES 106 f Paste 83184748 HINSERT INTO f Select All Indor id order number user info id VALUES 107 81 256488558 OLVq Y Z Ln W 7K m yOWF 742 INSERT INTO 7 Eind dor order number user info id WALUES 108 9 2 Replace UV SRwyM_ Ow 1630298013 20 INSERT INTO A Gih Indor id order number user info id VALUES 109 0 Ks 1134274192 N6 sQT3E08 amp 60v1H EndvOpa INSERT INTO 4 Incremental Search indor id order number user info id VALUES 110 0 Save 1613456316 4 pc ZQ SU lt _It4P sZ 0 amp FW4 _ ee The context menu of the editor area contains most of the standard text processing functions Cut Copy Paste Select All and functions for working with the script as a whole e g you can move the cursor to a particular line set markers toggle bookmarks etc Implementation of the Find Text and the Replace Text dialogs contributes to more efficient work with the SQL co
26. Native style option is currently supported for the Windows XP operating system only See also Trees and lists Check boxes Buttons Page controls Group boxes Fonts 2012 EMS Database Management Solutions 85 Data Generator for MySQL User s Manual 2 3 4 3 Check boxes Use the Check boxes section to customize the border style and the appearance of check boxes and radio buttons V Sample check box Sample radio button Border style This setting determines the manner in which check box and radio group borders are painted Use the drop down list to select the painting style that will be applied to the check boxes and radio groups None Single Thick Flat 3D UltraFlat Hot track This option specifies whether check boxes are highlighted when the mouse cursor is positioned over the check box controls Select this option to highlight check boxes in response to mouse movements Shadow If this option is selected a shadow is displayed for the check boxes and radio groups 2012 EMS Database Management Solutions 86 Data Generator for MySQL User s Manual 7 Native style This option determines whether the native Windows style will be applied to the check boxes and radio buttons The option has the highest priority for check boxes and radio buttons If this option is selected the check boxes and radio buttons are painted according to the native Windows
27. ULT CHARSET utf8 COMMENT InnoDB free 225280 kB Field list Preview He IL se H SE Gets Table Definition The drop down list at the top contains the tables that were selected for data generation at Step 2 Select a table to view its DDL Right click within the Table Definition area to call the popup menu allowing you to copy the DDL of the table to Windows clipboard 2012 EMS Database Management Solutions 61 Data Generator for MySQL User s Manual 2 1 4 3 Data Preview The Preview window allows you to browse the selected table data in the preview mode Note The data in preview are selected randomly according to specified parameters and are not actually inserted into the table i e a different set of values will be generated into the table To open the window click the Preview button available at Step 3 The grid contains all selected columns with data that will be generated according to the parameters you have specified at Step 3 If more convenient you can change the order of the columns by dragging their headers horizontally Click a column caption to sort items by values of this column in the ascending or the descending mode e ER Preview Lola ks ORDER_ID el CUSTOMER ID wel EMPLOYEE_ID SHIP VIA wel SALE DATE el SHIP 84 2984 70 UPS 2012 08 09 07 54 01 000008 2012 1 85 4652 97 UPS 2011 0
28. Unregistered Copy Trial Period 30 Day s Left This is a 30 day trial version To make sure you do not receive this notification any more you should purchase a software license and register your software http www sqimanager net products mysal datagenerator buy Please note the trial version of the program has a limitation of 100 records to be generated at a time Ce ee H SS Ces When you are done press the Next button to proceed to Step 1 See also Registration 2012 EMS Database Management Solutions 27 Data Generator for MySQL User s Manual Step 1 Setting connection properties At this step you should enter the necessary settings to establish connection to MySQL server Connection settings First select the connection type oca or remote Local connection is used to connect to MySQL server launched on the same machine where Data Generator for MySQL is running The Remote mode allows you to connect to MySQL server launched on another computer in the network By default the program uses local connection It is indicated by radio button Local selected If you wish to establish remote connection you should select the Remote radio button For remote connection you should also enter MySQL host name in the Host field For both types you should enter MySQL port to connect through in the Connection port field Afterwards you should specify authorization setti
29. a to several tables simultaneously Most MySQL data types supported Generating as many records as you want Defining fields for generating data Easy to use wizard interface Adjustable parameters for each field type including minimum and maximum value for integer types minimum and maximum length start and end char for string fields etc The possibility of saving all the generation parameters used within the current wizard session e The command line utility to generate data using the template file and more Scroll to top See also What s new 2012 EMS Database Management Solutions 15 Data Generator for MySQL User s Manual 1 7 EMS Data Generator FAQ Please read this page attentively if you have questions about EMS Data Generator for MySQL Table of contents e What is Data Generator for MySQL e What do I need to start working with EMS Data Generator for MySQL e What is the easiest way to configure the template files for the console application of Data Generator e How can I register the product e Are there any limitations implied in the trial version as compared with the full one Question answer list gt A What is Data Generator for MySQL Data Generator for MySQL is a powerful utility for generating test data to several MySQL database tables at once The wizard application allows you to define tables for generating data set value ranges generate char fields and BLOBs and many other
30. age controls Use the Page controls section of the Preferences dialog to customize the style of all Data Generator page controls Preferences et Sol V General Defaults r Language Tab style Interface Flat M Ea Trees and ists EJ Edit controls Hot track Check boxes Muitiline pages cc 7 Native style sl Page controls Group boxes Fonts Tab 1 Tab2 Tab3 Tabs are visual elements of tab controls Their purpose is to identify pages and switch between them Once a tab is clicked the corresponding page is selected Pages are container controls that represent the contents of tab controls Tab controls contain a single page whose context is to be updated each time the selected tab changes Page controls contain the number of pages equal to the number of tabs Tab style Use the drop down list to select the painting style that will be applied to the tab controls Tabs tabs are painted as notebook tabs Buttons the selected tab is painted as a pressed button other tabs are painted as released buttons Flat tabs are painted as notebook tabs but appear lowered slightly W Hot track This option specifies whether tab captions are highlighted when the mouse pointer hovers over tabs Select this option to enable tab highlighting W Multiline pages 2012 EMS Database Management Solutions 90 Data Generator for MySQL User s Manual This option specifies whether ta
31. anagement Solutions 38 Data Generator for MySQL User s Manual Data generation mode Generate random data Generate incremental data 9 Get data from list SQL query Get data from Field Parameters List of Values SQL query E Random order el B Malle 0 001 Lan o Lan p 0 001 0 01 Ge i m Get data from field This option allows you to specify a field to generate data from use the Table and Field drop down lists to select the source table and field that will be used to take data for generation Data generation mode Generate random data Generate incremental data Table CUSTOMER HE Field TAXRATE 2012 EMS Database Management Solutions 39 Data Generator for MySQL User s Manual 2 1 4 1 3 DATE field parameters Date fields are used for temporal values storage Values for this field can be generated randomly incrementally or they can be taken from a fixed list of values or SQL query or from an existing table field of the same data type The Generation properties panel allows you to define preferences for generating date values for date field types BIRTH DATE date The date fields are used for holding temporal values Values for this field can be generated randomly or taken from list of values Set NULL value in 10 of cases Select Data generation mode as follows Generate random data S
32. any local or remote MySQL server e Supported MySQL server versions from 3 23 up to 6 0 2012 EMS Database Management Solutions 9 Data Generator for MySQL User s Manual 1 3 Installation If you are installing Data Generator for MySQL for the first time on your PC e download the Data Generator for MySQL distribution package from the download page available at our site e unzip the downloaded file to any local directory e g C unzipped run MyDataGenSetup exe from the local directory and follow the instructions of the installation wizard after the installation process is completed find the Data Generator shortcut in the corresponding group of Windows Start menu If you want to upgrade an installed copy of Data Generator for MySQL to the latest version e download the Data Generator for MySQL distribution package from the download page available at our site e unzip the downloaded file to any local directory e g C unzipped e close Data Generator application if it is running e run MyDataGenSetup exe from the local directory and follow the instructions of the installation wizard See also System requirements 2012 EMS Database Management Solutions 10 Data Generator for MySQL User s Manual 1 4 Registration To make it easier for you to purchase our products we have contracted with share it registration service The share it order process is protected via a secure connec
33. ata Get data from list SQL query Get data from Field Parameters Initial value 0 Increment 1 Get data from list SQL query This panel allows you to define the list of values to generate bit data from You can enter these values directly into the editor by selecting the List of Values option To add a single value use the EZ Add Value button To load a list of values from an existing external file use the Bj Load from file button To save the list to an external file use the b Save to file button To remove a single value use the Delete Value button To remove all items from the list use the E Clear button You can also specify whether the values are to be taken in random order or in the order they have been inputted Alternatively you can set the SQL Query option and input an SQL query into the editor and the resulting dataset will be used as the list for data generation 2012 EMS Database Management Solutions 59 Data Generator for MySQL User s Manual Data generation mode Generate random data Generate incremental data 9 Get data from list SQL query Get data from Field Parameters List of Values V Random order SQL query BAW 10 00 kp Get data from Field This option allows you to specify a field to generate data from use the Table and Field drop down lists to select the source table and field that will be used
34. atabase structure and table data as a whole or partially SQL Query for PostgreSQL Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more amp Data Comparer for PostgreSQL Compare and synchronize the contents of your databases Automate your data migrations from development to production database Kal Scroll to top InterBase Firebird 89 SQL Management Studio for InterBase Firebird EMS SQL Management Studio for InterBase and Firebird is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before ER SQL Manager for InterBase Firebird Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Eg Data Export for InterBase Firebird Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more ES Data Import for InterBase Firebird Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface a Data Pump for InterBase Firebird Migrate from most popular databases MySQL SQL Server Oracle DB2 PostgreSQL etc to 2012 EMS Database Manag
35. bs are arranged across several rows If this option is enabled tabs are automatically arranged into the minimum number of rows required to fit all of them If this option is disabled tabs are displayed within a single row W Native style This option determines whether the native Windows style will be applied to the tab controls The option has the highest priority for the tab controls If this option is selected the tabs are painted according to the native Windows style regardless of other painting settings Note The Native style option is currently supported for the Windows XP operating system only See also Trees and lists Edit controls Check boxes Buttons Group boxes Fonts 2012 EMS Database Management Solutions 91 Data Generator for MySQL User s Manual 2 3 4 6 Group boxes Use the Group boxes section to customize all Data Generator group boxes to your liking Trees and lists EI Edit controls M Check boxes Native style Buttons CS Page controls Gel Coup bosxes Border style This setting determines the manner in which group box borders are painted Use the drop down list to select the painting style that will be applied to the group boxes None Single Thick Flat 3D UltraFlat W Shadow If this option is selected a shadow is displayed for the group boxes W Native style This option determines whether the native Windows style will be applied to the g
36. can set the SQL Query option and input an SQL query into the editor and the resulting dataset will be used as the list for data generation 2012 EMS Database Management Solutions A4 Data Generator for MySQL User s Manual Data generation mode Generate random data gt Generate incremental data Get data from list SQL query Get data from Field Parameters List of Values SQL query 7 Random order B H H 01 00 00 02 00 00 03 00 00 04 00 00 05 00 00 I 06 00 00 Get data from Field This option allows you to specify a field to generate data from use the Table and Field drop down lists to select the source table and field that will be used to take data for generation Data generation mode Generate random data Generate incremental data Get data from list SQL query Get data from Field Parameters Table diy Field last update 2012 EMS Database Management Solutions 45 Data Generator for MySQL User s Manual 2 1 4 1 5 STRING field parameters String fields are used for text data storage The values are sorted and compared on the basis of the collation of the character set assigned to the column Values for this field can be generated randomly with constraints or mask used incrementally or they can be taken from a fixed ist of values or SQL query or from an existing table field of the same data
37. cance If necessary you can set the second condition and specify the relation between the two conditions whether both of them should be satisfied AND or just any of them OR Use the _ character to represent any single symbol and use the character to represent any series of symbols in the condition string 2012 EMS Database Management Solutions 63 Data Generator for MySQL User s Manual 2 1 5 Step 4 Setting generation options At this step you can specify data generation options ES Data Generator for MySQL oS k Step 4 of 6 Set options for generating data Action Execute statements Save data generation script to file File name C Program Files EMS Data Generator for MySQL Script1 sql Action Specify the action to be taken at the next step of the wizard Execute statements Select this option to execute the script for data generation Save data generation script to file Select this option if you only need to save the script for data generation to a file without the script execution Execute statements and save data generation script to file Select this option to execute the script for data generation and save it to a file File name This box is enabled if the Save data generation script to file or Execute statements and save data generation script to file option is selected Type in or use the Explorer button to specify
38. cter set used by the application Major major version used to encrypt the passwords the value must not be changed Minor minor version used to encrypt the passwords the value must not be changed TUNNELING The section contains parameters required for connection with tunneling used the values correspond to the settings specified at Step 1 of the Wizard application for connection via SSH Tunnel or HTTP Tunnel if used 2012 EMS Database Management Solutions 103 Data Generator for MySQL User s Manual Parameter Description TunnelType indicates the tunneling type being used SSH HTTP or none TunnelType ttNotUse SSHHostName name of the host where SSH server is running SSHPort port on which SSH server is activated SSHUserName user on the machine where SSH server is running SSHPassword password to identify SSH server user encrypted SSHKey File path to the Private key used for the SSH connection if SSHUsekKeyFile True SSHUsekey File True SSH Private key is used False SSH Private key is not used PassPhrase passphrase for Private key if SSHUseKeyFile True HTTPurl URL to the emsproxy php script file uploaded to your web server for HTTP tunneling ADDITIONAL The section contains additional settings specified at Step 2 and Step 4 of the Wizard application Parameter Description TablesCount number of tables selected for data generation SqlExecute corresponds to the Execute statements option
39. data You can generate values for this field randomly or choose to take them froma specified list of files or SQL query or from an existing table field of the same data type The Generation properties panel allows you to define preferences for generating values for BLOB field type DETAILS blob ABLOB is a binary large object that can hold a variable amount of data You can generate values for this field randomly or choose several files to retneve data from them Set NULL value in 10 ofcases Select Data generation mode as follows Generate random data Set the Min length Max length values to define the minimum and the maximum length for generated values Data generation mode Generate random data Get data from fles SQL query Get data from Field Parameters Min length 0 Max length 500 Get data from files SQL query This panel allows you to define the list of files to generate BLOB data from You can specify the list of files to use their content as values for the BLOB field by selecting the List of Files option 2012 EMS Database Management Solutions 50 Data Generator for MySQL User s Manual To add a file use the a Add Value button To load a list of file paths from an existing external file use the EI Load from file button To save the list to an external file use the kl Save to file button To remove a single file use the el Delete Value button To remove all
40. de Find the complete list of the context menu items below The context menu allows you to e manage markers Drop Marker Collect Marker Swap Marker e toggle bookmarks allowing you to navigate through the query text and jump to a line with a particular number go to a line with specified number perform editing operations Undo Redo Cut Copy Paste Select all perform search and replace operations save the script to an external sq file 2012 EMS Database Management Solutions 67 Data Generator for MySQL User s Manual e format the selected code using SQL Formatter to make the code easier to read e use the Quick Code features select a character toggle a comment for a code fragment toggle case of the selected text indent unindent lines in the script Press the Back button to return to any of the previous steps the content of the editor area will not be lost If you press the Save button the script will be saved to an external file Pressing the Close button will result in closing the application before closing Data Generator will prompt for saving changes 2012 EMS Database Management Solutions 68 Data Generator for MySQL User s Manual 2 2 Using configuration files Data Generator for MySQL allows you to store its settings in external gtm files if you need to repeat data generation process several times You can load previously saved configuration settings to
41. e direction specified by the Direction setting Selected text Searches only within the currently selected text in the direction specified by the Direction setting You can use the mouse or block commands to select a block of text Origin Sa From cursor The search starts at the cursor s current position and then proceeds either forward to the end of the scope or backward to the beginning of the scope depending on the Direction setting 9 Entire scope The search covers either the entire block of selected text or the entire script no matter where the cursor is in the Editor area depending upon the Scope options W Mark search result with stack marker The option toggles marking search results If this option is selected stack markers are set at all search positions this makes it possible to jump from one marker search result to another within the text Click the Show All button to highlight every occurrence of the search string 2012 EMS Database Management Solutions 107 Data Generator for MySQL User s Manual 4 6 Replace Text dialog The Replace Text dialog is provided for searching and replacing text within the working area of the script editor Text to find Enter a search string in this box The Arrow Down button which can be found next to the input box allows you to select any of the previously entered search strings Text to replace This box allows you to enter a string to replace the s
42. earch string The Arrow Down button which can be found next to the input box allows you to select any of the previously entered strings To replace the search string with an empty string leave this input box blank Options Case sensitive This option can be used to differentiate uppercase characters from lowercase ones during the search process Whole words only Use this option to search for words only with this option off the search string might be found within longer words Regular expressions Recognizes regular expressions in the search string v Replace with template This option requires the Regular expressions option selection Enable this option to use regular expressions in the Text to replace field Expression used in this field will be applied to each string that matches the Text to find expression Note The syntax of regular expressions that can be used in the Text to find and the Text to replace fields is similar to that used in Perl regular expressions Comprehensive information about it can be found at http perldoc perl org perlre html Regular Expressions V Prompt on replace Check this option if you wish to be prompted before replacing upon each occurrence of the search string When this option is off the search string is replaced automatically 2012 EMS Database Management Solutions 108 Data Generator for MySQL User s Manual Replace Text Leg Text to find Ba z
43. ement Solutions 20 Data Generator for MySQL User s Manual InterBase Firebird Data Generator for InterBase Firebird Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters el DB Comparer for InterBase Firebird Compare and synchronize the structure of your databases Move changes on your development database to production with ease e DB Extract for InterBase Firebird Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for InterBase Firebird Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more Data Comparer for InterBase Firebird Compare and synchronize the contents of your databases Automate your data migrations from development to production database ei D a Scroll to top Oracle 89 SQL Management Studio for Oracle EMS SQL Management Studio for Oracle is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SQL Manager for Oracle Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different
44. er the values are to be taken in random order or in the order they have been inputted Alternatively you can set the SQL Query option and input an SQL query into the editor and the resulting dataset will be used as the list for data generation Use of the Sample text option allows you to generate fragments of previously defined text into the string field To define sample text used by default see the Default constraints section of the Preferences dialog 2012 EMS Database Management Solutions 48 Data Generator for MySQL User s Manual Data generation mode Generate random data Generate incremental data Get data from list SQL query Get data from Field Parameters List of Values SQL query Sample text 7 Random order F H H le gt Alabama a Alaska mW Get data from Field This option allows you to specify a field to generate data from use the Table and Field drop down lists to select the source table and field that will be used to take data for generation Data generation mode Generate random data Generate incremental data 5 Get data from list SQL query Parameters Table address Field AddressLine1 HE 2012 EMS Database Management Solutions 49 Data Generator for MySQL User s Manual 2 1 4 1 6 BLOB field parameters A BLOB is a binary large object that can store a variable amount of
45. ess MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for MySQL Migrate from most popular databases MySQL PostgreSQL Oracle DB2 InterBase Firebird etc to MySQL Data Generator for MySQL Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters DB Comparer for MySQL Compare and synchronize the structure of your databases Move changes on your development database to production with ease DB Extract for MySQL Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for MySQL Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more Data Comparer for MySQL Compare and synchronize the contents of your databases Automate your data migrations from development to production database Scroll to top 2012 EMS Database Management Solutions 18 Data Generator for MySQL User s Manual Microsoft SQL SG e dd B d RW WS SQL Management Studio for SQL Server EMS SQL Management Studio for SQL Server is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SQL Manager for SQL Server Simplify a
46. esult randomly generated values Data generation mode Generate random data Generate incremental data Get data from list SQL query Get data from Field Parameters Precision 6 Scale 2 Generate incremental data Specify the Initial value and the Increment properties to generate an ordered incremented sequence of values 2012 EMS Database Management Solutions 37 Data Generator for MySQL User s Manual Data generation mode Generate random data TTT DH Get data from list SQL query Get data from Field Parameters Initial value 0 Increment 1 Get data from List SQL query This panel allows you to define the list of values to generate floating point numeric data from You can enter these values directly into the editor by selecting the List of Values option To add a single value use the E Add Value button To load a list of values from an existing external file use the EA Load from file button To save the list to an external file use the b Save to file button To remove a single value use the Delete Value button To remove all items from the list use the Clear button You can also specify whether the values are to be taken in random order or in the order they have been inputted Alternatively you can set the SQL Query option and input an SQL query into the editor and the resulting dataset will be used as the list for data generation 2012 EMS Database M
47. et the date range by defining the minimum and the maximum values Check the Include Time option to generate non zero random time in addition to the date Data generation mode Generate random data Generate incremental data Get data from list SQL query Get data from Field Parameters Date Min 01 08 2012 Max 30 09 2012 Generate incremental data Specify the Initial Value and the Increment properties to generate an ordered incremented sequence of dates The incremented value is day 2012 EMS Database Management Solutions 40 Data Generator for MySQL User s Manual Data generation mode Generate random data Get data from bet SQL query Get data from Field Parameters Date Start 04 12 2012 M Increment 1 Y Get data from list SQL query This panel allows you to define the list of values to generate temporal data from You can enter these values directly into the editor by selecting the List of Values option To add a single value use the EJ Add Value button To load a list of values from an existing external file use the Bj Load from file button To save the list to an external file use the b Save to file button To remove a single value use the Delete Value button To remove all items from the list use the E Clear button You can also specify whether the values are to be taken in random order or in the order they have been inputted Alternatively you can set the
48. ey have been inputted Alternatively you can set the SQL Query option and input an SQL query into the editor and the resulting dataset will be used as the list for data generation Data generation mode Generate random data Get data from list SQL query Get data from Field Parameters List of Values SQL query 1 select geom_col from geomtable a 4 II p Get data from Field This option allows you to specify a field to generate data from use the Table and Field drop down lists to select the source table and field that will be used to take data for generation 2012 EMS Database Management Solutions 54 Data Generator for MySQL User s Manual Data generation mode Generate random data Get data from fist SQL query Get data from Field Parameters Table store D Field Sg 2012 EMS Database Management Solutions 55 Data Generator for MySQL User s Manual 2 1 4 1 8 ENUM and SET field parameters An ENUM or a SET field in MySQL is a string object with a value which is selected froma list of defined values Values for this field can be generated randomly or they can be taken from a fixed ist of values or SQL query The Generation properties panel allows you to define preferences for generating values for ENUM and SET field types e deparimen enum legal department accounting department administrative division An ENUM or SET beid is a st
49. ey while selecting the table names ER Data Generator for MySQL Step 2 of 6 Select databases and tables for data generation Select Tables Selected Tables ei sakila country Gs sakila customer Ei sakila employee CS sakila fiim Gs sakila film_actor Gs sakila fiim_category E sakia fim text sl sakila inventory Es sakila language Ei sakia mymfavontes Ei sakia mymreports sakila payment Es sakia rental E sakia staff Ei sakila store lt lt Back Next gt gt Close Please note that the order of data generation for tables depends on their position in the Selected Tables list This might be critical in case of generating data for linked tables You can change their order by dragging tables across the list 2012 EMS Database Management Solutions 30 Data Generator for MySQL User s Manual When you press the Next button at this step Data Generator for MySQL analyzes the order of data generation to avoid referential integrity conflicts and advises you to set a new order for data generation When you are done press the Next button to proceed to the next step 2012 EMS Database Management Solutions 31 Data Generator for MySQL User s Manual Step 3 Specifying generation parameters At this step you can select fields for generating data and set various data generation parameters Selected tables are disp
50. f EMS Data Generator for MySQL perform the following e receive the notification letter from Share it with the registration info e enter the Registration Name and the Registration Key from this letter e make sure that the registration process has been completed successfully check the registration information at the startup page Register Data Generator for MySQL m Please enter the registration information you received when purchasing Data Generator for MySQL Registration Name Registration Key Later Help See also Registration 2012 EMS Database Management Solutions 13 Data Generator for MySQL User s Manual 1 6 Version history Product name Data Generator 2005 for MySQL Data Generator 2005 for MySQL Data Generator 2005 for MySQL Data Generator 2005 for MySQL MySQL Data Generator Version Version 2 3 0 1 Version 2 2 0 1 Version 2 1 0 1 Version 2 0 0 1 Version 1 0 0 1 Full version history is available at http www sglmanager net datagenerator news Version 2 3 Implemented encrypted passwords storage Increased data generation speed Minor bug fixes and improvements Version 2 2 The Commit every option added The console version now creates log files System tables are not displayed any more Increased generation speed for string fields Added the opportunity to connect through Added the opportunity to connect through Version 2 1 Improved
51. for a string field 2012 EMS Database Management Solutions 105 Data Generator for MySQL User s Manual 4 5 Find Text dialog The Find Text dialog is provided for quick and flexible searching for specified text within the working area of the script editor Text to find Enter a search string in this box The Arrow Down button which can be found next to the input box allows you to select any of the previously entered search strings Options Case sensitive This option can be used to differentiate uppercase characters from lowercase ones during the search process Whole words only Use this option to search for words only with this option off the search string might be found within longer words Regular expressions Recognizes regular expressions in the search string e Find Text zm Text to find data x Options Direction Case sensitive Forward Whole words only Regular expressions Backward Scope Ongin 9 Global 9 From cursor Selected text Entire scope Mark search result with stack marker a Goa Ge Ga Direction Forward Searches from the current position to the end of the working area Backward Searches from the current position to the beginning of the working area Scope 2012 EMS Database Management Solutions 106 Data Generator for MySQL User s Manual Global Searches within the entire working area in th
52. generate data from use the Table and Field drop down lists to select the source table and field that will be used to take data for generation 2012 EMS Database Management Solutions 102 Data Generator for MySQL User s Manual 4 4 Configuration file format The configuration template file used by Data Generator for MySQL is divided into several sections each corresponding to a particular group of settings specified at different steps of the GUI application wizard General This section stores general information about the utility Parameter Description Product internal product name Version major version Comment This section stores the template file comment as specified optionally in the Save template options dialog Parameter Description Line lt N gt comment text where N stands for the comment line identifier Example LineO Data Generator for MySQL Line1 Template file Line2 Data generation 1 CONNECTION This section stores connection parameters to MySQL The parameters correspond to the values entered at Step 1 of the Wizard application and are obligatory Parameter Description Host host where the database resides if Remote 1 Port port on which MySQL is listening Remote 0 local connection 1 remote connection Login MySQL login Password password to identify the login encrypted Charset client character set specified for the connection FontCharset font chara
53. generated randomly or taken from list of values Set NULL value in 10 of cases Select Data generation mode as follows Generate random data Set the time range by defining the minimum and the maximum values Data generation mode Generate incremental data Get data from list SQL query Get data from Field Parameters Time 00 00 00 Min Max 23 59 59 2 Generate incremental data Specify the Start value and the Increment properties to generate an ordered incremented sequence of values 2012 EMS Database Management Solutions 43 Data Generator for MySQL User s Manual Data generation mode Generate random data Get data from ist SQL query Get data from Field Parameters Time Start 12 00 00 Increment 00 00 01 Get data from List SQL query This panel allows you to define the list of values to generate temporal data from You can enter these values directly into the editor by selecting the List of Values option To add a single value use the EZ Add Value button Bei To load a list of values from an existing external file use the EI Load from file button To save the list to an external file use the bl Save to file button To remove a single value use the Delete Value button To remove all items from the list use the E Clear button You can also specify whether the values are to be taken in random order or in the order they have been inputted Alternatively you
54. he preferable time format See also Setting general options Setting program language Defining interface style 2012 EMS Database Management Solutions 7 Data Generator for MySQL User s Manual 2 3 3 Setting program language The Language page is provided for managing Data Generator localization files You can create your own ng files similar to those available in the program_directory Languages folder add them to the list of available languages and set the new language as the program interface language Available languages Lists all the languages available for localization and the corresponding ng files Double click a language in the list to edit its name or the Ing file Language File none C Program Files EMS Data Generator for MySQL Languages Fre C Program Files EMS Data Generator for MySQL Languages Ge C Program Files EMS Data Generator for MySQL Languages Rus Language directory C Program Files EMS Data Generator for MySQL 2 Language directory Use the E button to specify the directory where the ng files are stored by default Load files This button is used for searching for ng files in the Language directory and adding all them to the Available languages list See also 2012 EMS Database Management Solutions 78 Data Generator for MySQL User s Manual Setting general options Setting default constraints Defining inte
55. ion is selected stack markers are set at all search positions this makes it possible to jump from one marker search result to another within the text Click the Replace All button to replace every occurrence of the search string If you have checked the Prompt on replace option the confirmation dialog box appears upon each occurrence of the search string 2012 EMS Database Management Solutions 110 Data Generator for MySQL User s Manual Credits Software Developers Sergey Sviridov Dmitry Schastlivtsev Alexey Butalov Alexander Zhiltsov Technical Writers Dmitry Doni Olga Ryabova Semyon Slobodenyuk Cover Designer Tatyana Mak urova Translators Anna Shulkina Serge Fominikh Team Coordinators Dmitry Schastlivisev Alexander Chelyadin Roman Tkachenko 2012 EMS Database Management Solutions
56. ions for data generation to SQL script appending to an existing file viewing editing script Added options for generating the same data into several columns Added options for generating string data according to sample text Implemented data preview Added options for generating data into dependent fields related as 1 n n records will be generated into the dependent table field for each record of the primary table Implemented data generation into fields of type GEOMETRY Data generation is now performed within a separate thread e Other minor improvements and bug fixes See also Version history 2012 EMS Database Management Solutions 8 Data Generator for MySQL User s Manual 1 2 System requirements System requirements for Data Generator for MySQL e 300 megahertz MHz processor 600 megahertz MHz or faster processor recommended Microsoft Windows NT4 with SP4 or later Microsoft Windows 2000 Microsoft Windows 2000 Server Microsoft Windows XP Microsoft Windows 2003 Server Microsoft Windows 2008 Server Microsoft Windows Vista Microsoft Windows 7 Microsoft Windows 8 e 64MB RAM or more 128MB or more recommended 20MB of available HD space for program installation e Super VGA 800x600 or higher resolution video adapter and monitor Super VGA 1024x768 or higher resolution video adapter and monitor recommended e Microsoft Mouse or compatible pointing device Possibility to connect to
57. items from the list use the Lal Clear button You can also specify whether the files are to be taken in random order or in the order they have been inputted Alternatively you can set the SQL query option and input an SQL query into the editor and the resulting dataset will be used as the list for data generation Data generation mode Generate random data Get data from files SQL query Gei data from Field Parameters List of Files SQL query AARAARAARAARAAAAAAAAAAAAAAAAAARAARASAAAAAARASAAAAAARAABRAAAAAAARAARAARAARAARAARAARAAAAARAAAAABAASAAAAAAAAARAAAASAAAAASAAARAARAAAAAAAASAAARAAAASRAARAAAAARASAAAAAARASAAAAAARAABAAARASAAARARAAARASRAARASAE m D img 01 bmp Get data from Field This option allows you to specify a field to generate data from use the Table and Field drop down lists to select the source table and field that will be used to take data for generation 2012 EMS Database Management Solutions 51 Data Generator for MySQL User s Manual Data generation mode Generate random data Get data from files SQL query Parameters Table EMPLOYEE des SG 2012 EMS Database Management Solutions 52 Data Generator for MySQL User s Manual 2 1 4 1 7 GEOMETRIC field parameters Geometric data types represent two dimensional spatial objects You can generate values for this field randomly or choose to take them froma s
58. layed in the Generate data for tree at the top left side of the window Table fields and their types are listed in the grid of the Field list area below Records count Set the number of data records to be generated for each table Clear Set this flag for a table to empty the table before data generation Preview Click the Preview button to browse the selected table data in the preview mode EB Data Generator for MySQL La 1 S k zl Step 3 of 6 Check fields to generate data for and set generation parameters Name Records count Clear fim id smalint 5 unsigned in Primary Key identity unique not null 5 H sakla 100 d Integer fields are used to hold exact numeric data Values for this field can be generated Si country 100 E d randomly incremental or taken from fixed list of values Si customer 100 EI employee 100 F H oo S Si fim actor 100 fim category 100 Data generation mode 400 LR Field list re ee Generate incremental data r i Get data from list SQL query Field Type V fim_id SMALLINT 5 UNSIGNED ED m tite VARCHAR 100 Parameters F release year YEAR 4 Initial value 1 ES m language id TINYINT 3 UNSIGNED Z Kees 1 z ES V onginal_language_k TINYINT 3 UNSIGNED E Im rental_duration TINYINT 3 UNSIGNED S E rental_rate DECIMAL 4 2 F length SMALLINT 5 UNSIGNED D replacement cost DECIMAL 5 2 M rating ENUM G PG PG 13 R NC 17 ec T
59. located or to any other webserver from which direct connections to your MySQL server are allowed This script exposes the MySQL API as a set of web services which is used by Data Generator for MySQL Note that the emsproxy php script file is included into the distribution package and can be found in Data Generator installation directory For details see HTTP tunneling options When you are done press the Next button to proceed to the next step 2012 EMS Database Management Solutions 29 Data Generator for MySQL User s Manual 2 1 3 Step 2 Selecting databases and tables At this step you should select tables for test data generation First you should select a database from the Select Database drop down list at the top of the window If the W Show databases option is disabled at the General Options tab of the Preferences dialog there will be no drop down list Type the database name manually in this case In the Available Tables list you can see all the tables belonging to the selected database To select a table you need to move it from the Available Tables list to the Selected Tables list In this list tables are displayed with their full names lt database_name gt lt table_name gt To cancel table selection just remove it fromthe Selected Tables list Use the buttons or drag and drop operations to move the tables from one list to another Hint To select multiple tables hold down the Shift or Ctrl k
60. ments for the SELECT INSERT UPDATE and DELETE clauses Advanced Excel Report Advanced Excel Report for Delphi is a powerful band oriented generator of template based reports in MS Excel Advanced Localizer Advanced Localizer is an indispensable component suite for Delphi for adding multilingual support to your applications Source Rescuer mle EMS Source Rescuer is an easy to use wizard application for Borland Delphi and C Builder which can help you to restore your lost source code Scroll to top 2012 EMS Database Management Solutions 24 Data Generator for MySQL User s Manual 2 Wizard Application Data Generator for MySQL wizard application provides easy to use wizard interface to set all data generation parameters visually e Using wizard application e Using configuration files e Setting program preferences Welcome to Data Generator for MySQL Wizard This Wizard allows you to generate random data of any type for MySQL database tables Click Next to start working with the wizard Product Information Developers Dmitry Schastivtsev Alexander Zhiitsov Alexey Butalov Sergey Svindov Homepage http www sqimanager net products mysql datagenerator Support Ticket System http www saqimanager net support Version 3 0 1 3 Registered to EMS Business license 1 ze Jl ze H lt lt Back Le oe See also Console Application
61. nd automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for SQL Server Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for SQL Server Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for SQL Server Migrate from most popular databases MySQL PostgreSQL Oracle DB2 InterBase Firebird etc to Microsoft SQL Server Data Generator for SQL Server Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters DB Comparer for SQL Server Compare and synchronize the structure of your databases Move changes on your development database to production with ease DB Extract for SQL Server Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for SQL Server Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more Data Comparer for SQL Server Compare and synchronize the contents of your databases Automate your data migrations from development to production database Scroll to top PostgreSQL SQL
62. ndent field Get data from list SQL query Parameters List of Values SQL query For each record of the primary table n records wil be generated into the foreign table NOTE Changing this value wil result in changing record count of the current table 4 D Y When you are done press the Next button to proceed to the next step of the Wizard 2012 EMS Database Management Solutions 33 Data Generator for MySQL User s Manual 2 1 4 1 Setting type specific properties 2 1 4 1 1 INTEGER field parameters Integer fields are used for exact numeric data storage Values for this field can be generated randomly incrementally or they can be taken froma fixed ist of values or SQL query or from an existing table field of the same data type The Generation properties panel allows you to define preferences for generating values for integer field types OO DEPT_ID int 11 Integer fields are used to hoki exact numeric data Values for this field can be generated randomly incremental or taken from fixed list of values T Set NULL value in 10 of cases Select Data generation mode as follows Generate random data The value is generated randomly within the defined interval the minimum and the maximum values Data generation mode Generate random data Generate incremental data Get data from list SQL query Get data from Field Parameters Min value 1 W Use formula This o
63. nfiguration file Data Generator templates are loaded within the Open template dialog To open this dialog press the Tools button and select the Load template popup menu item Save Template A Load Template d Preferences Reopen Template gt Please note that you can reopen a template at any step of the wizard using the corresponding popup menu item of the Tools menu e Saving configuration file e Save Template options 2012 EMS Database Management Solutions 72 Data Generator for MySQL User s Manual 2 3 Setting program preferences Data Generator for MySQL provides full customization of the program interface by setting various options within the Preferences dialog This chapter is intended to inform you how to use these options General options These options define general behavior of Data Generator for MySQL Default constraints This page allows you to set the constraints for field values used by default in the generation process Language This page allows you to select a language to be applied for your copy of Data Generator for MySQL Interface This branch contains several pages with a number of options allowing you to customize the application interface style according to your liking Save Template KO Load Template Reopen Template gt See also Using wizard application Using configuration files 2012 EMS Database Management Solutions 73 Da
64. ngs Login and Password The default superuser name is root and the default password is empty If necessary use the drop down list to specify the preferable Client charset to be used by the application E Data Generator for MySQL koa Step 1 of 6 Set MySQL server connection properties Local Login root Remote Password Host doom_server z Cent charset DEFAULT z Connection port 3306 z Don t use tunneling Connect through the Secure SHel SSH tunnel SSH host name vadsrv z SSH user name tester SSH key fie C ASSHKeys dsa_key ppk Connect through the HTTP tunnel lt a em om 2012 EMS Database Management Solutions 28 Data Generator for MySQL User s Manual Please note that you should have sufficient privileges to write to the destination database on MySQL server Tunneling settings To setup the connection via SSH tunnel input the following values in the corresponding fields e SSH host name is the name of the host where SSH server is running e SSH port indicates the port where SSH server is activated e SSH user name stands for the user on the machine where SSH server is running Note it is a Linux Windows user not a user of MySQL server e SSH password is the Linux Windows user password For details see SSH tunneling options To use HTTP tunneling just upload the tunneling script to the webserver where MySQL server is
65. nt is not altered or edited in any way Document generated on 06 12 2012 3 Data Generator for MySQL User s Manual Table of Contents Part Welcome to EMS Data Generator What s EE System requirements ccccceeeeceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeseeeeeeeeeeeeeeesees IS CHE Le E Regi Ara NON SER REE RRS SSR Se SEE SEES SSES EE SSES EES How to register Data Generator c cecceeeeeeeeeeeeeeeeeeeeeeeeeeeneeeeeeeees Version HITO uaran ED EUD ERR EKO EMS Data Generator FAQ ccccceeseceeeeeeeeeeeeeeeeeeeeeseeeeeeeseeeeeeeeeeeeeees Other EMS ProQuctS aidaa ioare a aeai ENEE ENEE ENER KN Part Il Wizard Application Using wizard application cccceececeeeeeeeeeeeeeeeeeeeeeeeeeeeeseeeeeeneeeeeeees Getting starte d SE EEN E A S DER TE hanke Step 1 Setting connection properties s ssnsusennnsnsnnnnnnrnnnnnnrnnnnnnnnnnnnnnnnnnennnnnn en Step 2 Selecting databases and tables 21 M ssssee seerne Step 3 Specifying generation parameters csseceeecsseceeeeseerseeseeesseeseeseeseneneee Setting type specific properties ee eee ee eee ee nesses ren rkr en kknns INTEGER field parameters secccscesices lerne r rene oder esse eres FLOAT field parameters gs 3 ur rear RNA DATE field parameters TIME field parameters STRING field parameters BLOB field parameters GEOMETRIC field parameters ENUM and SET field parameters
66. of the Action radio group available at Step 4 1 enabled O disabled SqlSave corresponds to the Save data generation script to file option of the Action radio group available at Step 4 1 enabled O disabled SaveFile path to the script file if SqiSave 1 BlobFile the parameter is not used by Data Generator for MySQL ExportBlobType the parameter is not used by Data Generator for MySQL TABLE XX The section is repeated for all tables the settings are specified at Step 3 of the Wizard application Parameter Description Database indicates the name of the database where the table is located TableName indicates the name of the table to generate data into RecordCount number of records to be generated ClearBeforeGenerationi leads to emptying table O leaves the table as it was before data generation TABLE_XX_FIELD_YY The section is created for each field of each table Parameter Description DoGenerate O indicates that the field is excluded 1 indicates that the field is included IncludeNulls 1 specifies that the NULL values are set for certain percent of cases O disables this option 2012 EMS Database Management Solutions 104 Data Generator for MySQL User s Manual NumNulls GenMethod GenFromSQL SQL UsingMask Mask MinInt Max tot UseFormula Formula Digits Precision MinDate MaxDate IncludeTime MinTime MaxTime MinLength MaxLength StartChar EndChar Charset InitialValue IncrementS
67. ontents of your databases Automate your data migrations from development to production database 2012 EMS Database Management Solutions 22 Data Generator for MySQL User s Manual Scroll to top Tools amp components Advanced Data Export Component Suite for Borland Delphi and NET will allow you to save Gel Advanced Data Export your data in the most popular office programs formats Za Advanced Data Export NET ef Advanced Data Export NET is a component suite for Microsoft Visual Studio NET 2003 2005 2008 and 2010 that will allow you to save your data in the most popular data formats for the future viewing modification printing or web publication You can export data into MS Access MS Excel MS Word RTF PDF TXT DBF CSV and more There will be no need to waste your time on tiresome data conversion Advanced Data Export will do the task quickly and will give the result in the desired format Advanced Data Import Advanced Data Import Component Suite for Delphi and C Builder will allow you to import your data to the database from files in the most popular data formats Advanced PDF Generator f Advanced PDF Generator for Delphi gives you an opportunity to create PDF documents with your applications written on Delphi or C Builder Advanced Query Builder Advanced ee Builder is a powerful component suite for Borland Delphi and C Builder intended for visual building SQL state
68. over the button otherwise the button is transparent 2012 EMS Database Management Solutions 84 Data Generator for MySQL User s Manual Always a button is always transparent Hide inactive a button is drawn only when the editor has focus otherwise the button is invisible Hide unselected a button is drawn when the editor has focus or when the mouse cursor is positioned over the editor region otherwise the button is invisible Edges This group defines which edges are displayed within an editor Check uncheck the boxes to hide show individual edges of the edit controls IM Left if unchecked the left border edge is invisible W Right if unchecked the right border edge is invisible W Top if unchecked the top border edge is invisible V Bottom if unchecked the bottom border edge is invisible v Hot track This option specifies whether editor items are highlighted when the mouse cursor is positioned over an edit control Select this option to highlight an edit control in response to mouse movements 7 Shadow If this option is selected a shadow is displayed for the edit controls W Native style This option determines whether the native Windows style will be applied to the edit controls The option has the highest priority for edit controls If this option is selected the edit controls are painted according to the native Windows style regardless of other painting settings Note The
69. oxes Buttons Page controls Group boxes Fonts 2012 EMS Database Management Solutions 83 Data Generator for MySQL User s Manual 2 3 4 2 Edit controls Use the Edit controls section to customize the appearance of various Data Generator for MySQL edit controls Border style Button style Button transparency etc Preferences ween amp General Defaults C Language Border style Button style 2 Interface Ultrafiat Ultrafiat fal Trees and ists D e KEE Button transparency Edg 7 Left Check boxes None VIL FS Page controls J d Top Group boxes Shadow Fonts Native style Bottom Sample text edit Item 1 Item 2 Item 3 Sample button edit Sample combo box Border style Button style Use these drop down lists to specify the style around an editor the edit control borders and select the painting style that will be applied to the edit control buttons ellipsis button arrow down combo box button etc respectively None Single Thick Flat 3D UltraFlat Button transparency Represents the button transparency mode within an editor Use the drop down list to specify the transparency that will be applied to the edit control buttons ellipsis button arrow down combo box button etc None a button is always displayed in a non transparent fashion Inactive a button is drawn when the editor has focus or when the mouse cursor is positioned
70. pecified ist of values or SQL query or from an existing table field of the same data type The Generation properties panel allows you to define preferences for generating values for geometric field types GeomCol geometry Geometnc data types represent two dimensional spatial objects Values for this field can be generated randomly or taken from bet Set NULL value in 10 ofcases Select Data generation mode as follows Generate random data The coordinates are generated randomly within the defined intervals the minimum and the maximum values Get data from list SQL query Get data from Field Parameters Min X 10 Geometry type Point Max X 10 Min Y 15 Max Y 15 Get data from list SQL query This panel allows you to define the list of values to generate geometric data from You can enter these values directly into the editor by selecting the List of Values option To add a single value use the EZ Add Value button 2012 EMS Database Management Solutions 53 Data Generator for MySQL User s Manual To load a list of values from an existing external file use the B Load from file button To save the list to an external file use the b Save to file button To remove a single value use the Delete Value button To remove all items from the list use the Lal Clear button You can also specify whether the values are to be taken in random order or in the order th
71. pport Localisable user friendly wizard interface Ability to save and edit data generation script without actual script execution Generating data into several tables of different databases at one host Support for all MySQL data types including ENUM SET GEOMETRY Various data generation modes for each field including list random incremental data generation and more Ability to use SQL query results as the list of values for data generation Ability to get data from another field for data generation Ability to preview the data grid for each table Automatic control over referential integrity for data generation into linked tables Wide variety of generation parameters for each field type Ability to set NULL values for a specified percent of cases Ability to empty tables before data generation Possibility of saving all the generation parameters specified within the current wizard session e The command line utility to generate data using the configuration file Product information Homepage http www sqlmanager net en products mysql datagenerator Support Ticket http www sqlimanager net support System Register online at http www sqlmanager net en products mysql datagenerator bu 2012 EMS Database Management Solutions H Data Generator for MySQL User s Manual 1 1 What s new Version Release Date Data Generator for MySQL 3 0 July 2 2008 What s new in EMS Data Generator e Implemented Unicode support Added opt
72. ption allows you to correct your data according to a formula x is a randomly generated value here Addition substraction multiplication dividing and exponentiation 2012 EMS Database Management Solutions 34 Data Generator for MySQL User s Manual operations can be used Generate incremental data Specify the Initial value and the Increment properties to generate an ordered incremented sequence of values Data generation mode Generate random data Get data from list SQL query Get data from Field Parameters Initial value 1 Increment 1 Get Data from List SQL query This panel allows you to define the list of values to generate integer data from You can enter these values directly into the editor by selecting the List of Values option To add a single value use the E Add Value button NER To load a list of values from an existing external file use the o Load from file button To save the list to an external file use the b Save to file button To remove a single value use the Delete Value button To remove all items from the list use the E Clear button You can also specify whether the values are to be taken in random order or in the order they have been inputted Alternatively you can set the SQL Query option and input an SQL query into the editor and the resulting dataset will be used as the list for data generation 2012 EMS Database Management Solutions
73. rface style 2012 EMS Database Management Solutions 79 Data Generator for MySQL User s Manual 2 3 4 Defining interface style The Interface section of the Preferences dialog allows you to customize the application interface style to your liking e Trees and lists e Edit controls e Check boxes e Buttons e Page controls e Group boxes e Fonts Use the Scheme name drop down list to select an interface scheme according to your liking Classic Office XP style Windows XP native style etc Delete It is also possible to create one s own interface scheme if necessary e set your preferences within the available branches of the Interface node Trees and Lists Edit Controls Check Boxes Buttons Page controls Group Boxes Fonts e return to the Interface page and click the Save As button e specify the scheme name in the Input scheme name dialog 2012 EMS Database Management Solutions 80 Data Generator for MySQL User s Manual a Input scheme name Scheme name My new visual scheme L o JL ee Note For your convenience the previews illustrating the changes are displayed in the Sample area of each branch of the Interface node See also Setting general options Setting default constraints Setting program language 2012 EMS Database Management Solutions 81 Data Generator for MySQL User s Manual 2 3 4
74. ring object with a value chosen from a list of allowed values Values for this field can be generated randomly or taken from bet of values Set NULL value in 10 ofcases Select Data generation mode as follows Generate random data There are no additional parameters for this field type Get data from list SQL query Parameters This field wil be generated randomly according to the field definition Get data from List SQL query This panel allows you to define the list of values to generate list data from You can enter these values directly into the editor by selecting the List of Values option To add a single value use the EZ Add Value button To load a list of values from an existing external file use the EI Load from file button 2012 EMS Database Management Solutions 56 Data Generator for MySQL User s Manual To save the list to an external file use the Save to file button To remove a single value use the Delete Value button To remove all items from the list use the Clear button You can also specify whether the values are to be taken in random order or in the order they have been inputted Alternatively you can set the SQL Query option and input an SQL query into the editor and the resulting dataset will be used as the list for data generation Data generation mode Generate random data Get data from list SQL query Parameters List of Values SQL query
75. roup boxes The option has the highest priority for the group boxes If this option is selected the group boxes are painted according to the native Windows style regardless of other painting settings 2012 EMS Database Management Solutions 92 Data Generator for MySQL User s Manual Note The Native style option is currently supported for the Windows XP operating system only See also Trees and lists Edit controls Check boxes Buttons Page controls Fonts 2012 EMS Database Management Solutions 93 Data Generator for MySQL User s Manual 2 3 4 7 Fonts This section of the Preferences dialog allows you to specify fonts used in the application The box below displays the sample text with the selected font applied Ea Trees and ists EJ Edit controls RI Check boxes Buttons PS Page controls C Group boxes System font name Defines the font used by Data Generator for MySQL Select the font name from the drop down list of available system fonts 2012 EMS Database Management Solutions 94 Data Generator for MySQL User s Manual System font name Th Arial Unicode MS sl Arial Unicode MS Tp Arabic Typesetting Th Anal System font size Defines the font size used by Data Generator for MySQL Type in or use the drop down list to select the required value See also Trees and lists Edit controls Check boxes B
76. swords used for access to the databases automatically upon closing the application Please note that checking this option saves the latest password used for connection to the database including the SSH server password Show DDL for table in hint This option enables disables hints that popup when the mouse cursor is positioned over the table names within the Generate Data for area at Step 3 v Show databases This option enables disables the Select Database drop down list at Step 2 of the wizard If you check this option you can select the database from the list otherwise you must type the database name manually See also Setting default constraints Setting program language Defining interface style 2012 EMS Database Management Solutions 75 Data Generator for MySQL User s Manual 2 3 2 Setting default constraints On this page you can define the default constraints for all supported data types Set NULL value in of cases This option allows you to specify the percentage of records that will remain NULL by default Min Length Max Length 0 E 1 427 V Include new line V Windows new line Sample Text Lorem ipsum dolor sit amet consectetuer adipiscing elit sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat Ut wisi nisi ut aliquip ex ea commodo consequat Duis autem vel eum inure dolor in hendrerit in vulputate velit esse molestie consequat
77. ta Generator for MySQL User s Manual 2 3 1 Setting general options This page allows you to define general options of the application Number of records to generate Sets the quantity of records generated by default Commit every records Specifies the number of records in each block of the generation script to be supplemented with the COMMIT statement Number of records to preview Sets the quantity of records used in the Data Preview window by default Preferences tee Som v Defaults v Language Number of records to generate 100 t Oy rf a Interface c zt every 100 SL Number of records to preview 100 7 Confirmation on exit 7 All fields selected by default V BLOB fields selected by default Clear tables before generation Save passwords V Show DDL for table in hint Show databases Wi Confirmation on exit Enables disables confirmation upon exiting the program W All fields selected by default Check this option to include all fields into the data generation process by default W BLOB fields selected by default Uncheck this option if you need to exclude BLOB fields from the generation process by default 2012 EMS Database Management Solutions 74 Data Generator for MySQL User s Manual vi Clear tables before generation Set this option to empty tables before data generation vi Save passwords Setting this option allows you to save pas
78. tep UseNewLine WinNewLineStyle SampleText the percentage of field values to be set to NULL defines Data generation mode O stands for incremental data generation 1 random data generation 2 refers to Get data from list SQL query option 3 from another field O the direct list of values is taken for data generation 1 SQL query is used text of the SQL query from which a list of values is taken for generation as the result of the SQL query execution O no mask is used for string field values 1 generation of string field values by mask mask for string field values generation minimal value for integer fields maximal value for integer fields 0 no formula 1 a formula is applied for data generation formula for data generation e g x 2 1 digits quantity for float fields precision value for float fields minimum value for date fields maximum value for date fields indicates whether time is added for DATETIME fields minimum value for time fields maximum value for time fields minimum length for string fields maximum length for string fields first char code for generating strings last char code for generating strings field character set the initial value for data generation into the field specifies the step to increment values for GenMethod 0 1 a line feed is used for a new line 0 no line feeds used style to be applied to line feeds 1 Windows style O Unix style sample text to be generated
79. tion and makes online ordering by credit debit card quick and safe The following information about share it is provided for your convenience Share it is a global e commerce provider for software and shareware sales via the Internet Share it accepts payments in US Dollars Euros Pounds Sterling Japanese Yen Australian Dollars Canadian Dollars or Swiss Franks by Credit Card Visa MasterCard EuroCard American Express Diners Club Bank Wire Transfer Check or Cash If you have ordered EMS software online and would like to review your order information or if you have questions about ordering payments or shipping procedures please visit our Customer Care Center provided by Share it Please note that all of our products are delivered via ESD Electronic Software Delivery only After purchase you will be able to immediately download the registration keys or passwords and download links for archives of full versions Also you will receive a copy of registration keys or passwords by e mail Please make sure to enter a valid e mail address in your order If you have not received the keys within 2 hours please contact us at sales sqlmanager net To obtain MORE INFORMATION on this product visit us at http sqlmanager net en products mysql datagenerator Product distribution Data Generator for MySQL Business license 1 Year Maintenance Data Generator for MySQL Business license 2 Year Maintenance Data Generator for MySQL B
80. tively to the SSH server in this case For example if both MySQL and SSH servers are located on the same computer you should specify localhost as host name instead of the server external host name or IP address 7 Use Private Key for authentication If the SSH encryption is enabled on the SSH server a user can generate a pair of cryptographic keys the Private key and the Public key The Public key is placed on the SSH server and the Private key is the part you keep secret inside a secure box that can only be opened with the correct passphrase or an empty string as the passphrase When you wish to access the remote system you open the secure box with your passphrase if any and use the private key to authenticate yourself with the Public key on the remote Linux computer SSH Key file Specify the location the secure box of the Private key file on your local machine Supported Private Key file formats are OpenSSH Putty SSH com Note that you need to trust your local machine not to scrape your passphrase or a copy of your Private key file while it is out of its secure box Enter passphrase ok cance 2012 EMS Database Management Solutions 100 Data Generator for MySQL User s Manual 4 2 HTTP tunneling options To use HTTP tunneling just upload the tunneling script to the webserver where MySQL server is located or to any other webserver from which direct connections to your MySQL
81. to take data for generation Data generation mode Generate random data Generate incremental data Get data from fist SQL query Get data from Field Parameters Table employee Fe se ED 2012 EMS Database Management Solutions 60 Data Generator for MySQL User s Manual 2 1 4 2 Viewing table DDL When you select a database in the Generate data for tree you can select a table belonging to the database and view its DDL structure within the Table Definition area at the right side of the window Hint If more convenient you can select the Show DDL for table in hint option available in the General section of the Preferences dialog to enable hints that popup when the mouse cursor is positioned over the table names within the Generate Data for area ES Data Generator for MySQL rr Step 3 of 6 Check fields to generate data for and set generation parameters Name e Records count Clear ER actor a E 100 Lei 2 CREATE TABLE actor actor 100 m actor id smallint 5 unsigned NOT NULL EB address 100 AUTO INCREMENT category 94 3 first name varchar 45 NOT NULL city 100 4 last name varchar 45 NOT NULL Si country 100 al last update timestamp NOT NULL DEFAULT ER customer 100 D 5 CURRENT_TIMESTAMP ON UPDATE EB emplovee 100 ai el CURRENT_TIMESTAMP PRIMARY KEY actor_id KEY dx actor last name last name Field Type ENGINE InnoDB DEFA
82. type The Generation properties panel allows you to define preferences for generating string values for string based field types first name varchar 45 not null String fiekis are used to hold text data their values are sorted and compared based on the collation of the character set assigned to the column Values for this field can be taken from fixed list of values generated randomly or by mask Select Data generation mode as follows Generate random data String random data can be generated in two ways by using constraints or by typing the mask e Using constraints Set the Min length Max length values to define the minimum and the maximum length for generated values You can also specify the Start char and the End char segments to be used for string values generation Data generation mode Generate random data Generate incremental data Get data from list SQL query 5 Get data from Field gt Using mask asci ASCII 0 2 Start char Aces 50 Z End char z 122 f V Include new line V Windows new line 2012 EMS Database Management Solutions 46 Data Generator for MySQL User s Manual e Using mask Check the option to generate values by mask Use the Masks window to create and edit various masks for string data generation the A and the a characters are replaced with a random letter from A to Z and from a to z the MN character is replaced with a random digit
83. usiness license 3 Year Maintenance Register Data Generator for MySQL Non commercial license 1 Year Maintenance Now Data Generator for MySQL Non commercial license 2 Year Maintenance Data Generator for MySQL Non commercial license 3 Year Maintenance Data Generator for MySQL Trial version Download Now EMS Maintenance Program provides the following benefits e Free software bug fixes enhancements updates and upgrades during the maintenance period e Free unlimited communications with technical staff for the purpose of reporting Software failures e Free reasonable number of communications for the purpose of consultation on operational aspects of the software After your maintenance expires you will not be able to update your software or get technical support To protect your investments and have your software up to date you need to renew your maintenance You can easily reinitiate renew your maintenance with our online speed through 2012 EMS Database Management Solutions 11 Data Generator for MySQL User s Manual Maintenance Reinstatement Renewal Interface After reinitiating renewal you will receive a confirmation e mail with all the necessary information See also How to register EMS Data Generator 2012 EMS Database Management Solutions 12 Data Generator for MySQL User s Manual 1 5 How to register Data Generator To register your newly purchased copy o
84. uttons Page controls Group boxes 2012 EMS Database Management Solutions 96 Data Generator for MySQL User s Manual 3 Console Application Additionally to the GUI version which is implemented in the form of a wizard application the installation package of Data Generator for MySQL includes the console version which is intended for being run from Windows command line with a template file name used as the execution parameter Program Files EMS Data Generator for MySQL gt MyDataGenC e Data Generator for MySQL command line utility is intended for quick and powerful data generation to MySQL tables e Using console application See also Wizard Application 2012 EMS Database Management Solutions 97 Data Generator for MySQL User s Manual 3 1 Using console application All the generation options are set in template gtm files A template can be also used in the Console version of Data Generator for MySQL To create a template file follow the instructions below e start Data Generator for MySQL Wizard Application e set all the required options in all steps of the wizard e test the generation process at the last step e save all generation options in the template file The easiest way to start Data Generator for MySQL console application is to double click the generated gtm template file The other way is to enter the command line and type the appropriate command Usage
85. vel Sum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zz delenit augue duis dolore te feugait nulla facilisi Default Integers Use this tab to set the desired minimum and maximum integer values to be generated Default Floats Use this tab to set the number of digits and the precision for the floating point numeric values Default Strings Use this tab to set the range of characters to be used for generating string values for example from A to z and their minimum maximum length Include new line Select this option to allow line feeds in generated string values 2012 EMS Database Management Solutions 76 Data Generator for MySQL User s Manual v Windows new line Select this option to specify Windows style line feeds Sample Text If more convenient you can input any string that will be used as sample text You can choose to generate sample text when setting generation parameters for strings Default Date Use this tab to set the date range by defining the minimum and the maximum values Check the Include Time option to generate non zero random time in addition to the date Date format Type in or use the drop down list to specify the preferable date format Default Time Use this tab to set the time range by defining the minimum and the maximum values Time format Type in or use the drop down list to specify t

Data Generator for MySQL

Contents

Download Pdf Manuals

Related Search

Related Contents