Once you created the CSV files, you need to import them into your database.

Go to the appropriate section and read on how exactly you can do it:

MySQL
Microsoft SQL Server
Oracle
IBM DB2

Or go back to the MockupData User Guide.

Import CSV files into MySQL database

To insert the data from file 'table1.csv' into table called 'table1' you would use LOAD DATA command. Basically it goes like this:

LOAD DATA INFILE 'table1.csv' INTO TABLE table1
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'

You can read more and find numerous other options (including loading only a subset of columns) in the MySQL manual. To do that, start here.

Many graphical mySQL clients have very nice import dialogs for loading data. One such popular (free) desktop tool is www.HeidiSql.com. For online tool people often use www.phpmyadmin.net

Import CSV files into Microsoft SQL Server

To insert the data from file 'table1.csv' into table called 'table1' you would probably want to use BULK INSERT command. Basically it goes like this:

BULK INSERT table1
FROM 'table1.csv'
WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')

This method, along with others (e.g. bcp bulk copy utility) and their complete comparison, is thoroughly explained in MSDN library. Good place to read more is here: "About Bulk Import and Bulk Export Operations".

To import files via graphical interface, use the "SQL Server Import and Export Wizard". You can start it via Start menu or the command line, explained here in MSDN library: "SQL Server Import and Export Wizard". Or you can use one of other graphical clients, including above mentioned free tool www.HeidiSql.com

Import CSV files into Oracle database

To insert the data from file 'table1.csv' into table called 'table1' you would write the control script and then execute it via the SQL Loader utility.

SQL Loader utility is invoked like this:

sqlldr username@server/password control=loader.ctl

And the basic sample 'loader.ctl' script would look like this:

LOAD DATA INFILE 'table1.csv'
INTO TABLE table1
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'

You can read all the details on how to use the SQL Loader utility in SQL Loader FAQ. To do that, start here.

Another method would be to use the external table: "External Tables".

Also there is yet another but graphical (ie. "wizard") method. It would be to use "Import data" command from the SQL Developer.

Import files into IBM DB2 database

To insert data from file 'table1.csv' into table called 'table1' you would use the IMPORT command from the CLP command line interface like this:

IMPORT FROM "table1.csv"
OF DEL MODIFIED BY CHARDEL"" COLDEL;
INSERT INTO table1

You can read all about the numerous IMPORT parameters, delimiters syntax and priority, etc directly in DB2 manual.

If you want a graphical interface (ie. "wizard"), use the "Import" command of the Command Center. You can start Command Center from the Start menu.

To go back to the MockupData User Guide, click here.