Convert to SQL

Convert large CSV and Excel files into optimized and awesome SQL import files, like a boss.

FAQ


Conversions

Is the service fast? Does it take long time to convert my csv / spreadsheet file?

We worked hard on fine-tuning C2S into being very fast, but the time depends entirely on the size of the file and the kind of data it contains. The big majority of the conversions are done within the hour. In most cases, it's just a matter of minutes.

What happens with my source spreadsheet and SQL import data afterwards, do you keep it?

The system deletes the source file directly after the conversion is done, after 24 hours your converted file is also deleted.

Is the schema defined in the same SQL file as the dump?

No, we deliver it as a seperate SQL file. This makes it easier to edit it rather then if it would have been included directly in the SQL dump file.

What is the Laravel Migration option?

With this option we generate and include a migration php-file with your download. Laravel Migration is a feature of the Laravel PHP Framework. It is like version control for your database. Click here for more info!

Do you support multiple worksheets in a Excel file?

No - the system only takes the first worksheet of the excel file, even if it contains more then one. So if the file contains multiple ones you need to seperate them into different files and upload them one for one.

Is the traffic secure?

Yes, all traffic on C2S is encrypted with strong TLS/SSL over HTTPS.

Tips & tricks


Join the schema.sql and dump.sql content into a new file

Sometimes it's easier just to concatenate both files into one joined dump file before the import. You can use the following commands for that:

Linux/MacOS Terminal

$ cat path/to/schema.sql path/to/dump.sql >> path/to/joined-import-file.sql

Windows command line

: type schema.sql dump.sql > joined-import-file.sql

How to create your table and import the dump

With MySQL/MariaDB console

> use YOUR_DATABASE_NAME;
> source path/to/schema.sql;
> source path/to/dump.sql;

With PostgreSQL (psql) console

> \c YOUR_DATABASE_NAME;
> \i path/to/schema.sql;
> \i path/to/dump.sql;

With SQL Server, from command line

: sqlcmd -S server_name\instance_name -d database_name -i C:\path\to\schema.sql -o C:\path\where\you\want\output-file.txt
: sqlcmd -S server_name\instance_name -d database_name -i C:\path\to\dump.sql -o C:\path\where\you\want\output-file.txt

Problems with artisan migrate:rollback?

Sometimes you might experience this problem. Because the Laravel migration file was not generated by your application, using $ php artisan migrate:rollback might throw a "Class not found" FatalErrorException. Thankfully, there is a easy fix for this. Just run:

$ composer dump-autoload