SQL Data Generator 3

Examples using the command line

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.


Didn't find what you were looking for?