Examples using the command line
Published 27 November 2013
This topic provides some examples of how to use the command line interface.
For information about all the switches you can use with the SQL Data Generator command line, see Command line syntax.
Using a SQL Data Generator project
In this example, we'll populate a database with data using settings saved in a SQL Data Generator project file:
sqldatagenerator /project:"C:\SQL Data Generator\Projects\widgetdata.sqlgen"
For information about setting up a project file, see Worked example - setting up the data generator.
Specifying a database
In this example, we'll specify a database to populate with data:
sqldatagenerator /server:Widget_Server\SQL2012 /database:WidgetTest /username:User1 /password:P@ssw0rd
When you specify a database, SQL Data Generator automatically assigns generator settings for all columns. If you want to customize the generation settings, we recommend using a project file instead.