Import data from CSV to SQL 2012
Budget: €250 – €750 EUR
We have an open source data in various formats (CSV, txt, mdb). Files are available online.
In fact, that are some statistics data, for years 2014, 2015.... 2021.
There are approx. 8 files, with approx 1Gb of data in each files.
All data from source should contain the same fields.
We need someone to:
- create initial SQL 2012 database with same fields as fields in source
- we don't know the exact data type and length of initial fields
- database codepage must be WIN1250
- data from all source files must be imported to newly created database
First option is to create new database (with the same structure / fields) for each year.
Another option is to create 1 database, with new table (with the same structure / fields) for each year.
A final result should be a database files (for example bak files), which could be easy to import to our SQL 2012 server.
In fact, that are some statistics data, for years 2014, 2015.... 2021.
There are approx. 8 files, with approx 1Gb of data in each files.
All data from source should contain the same fields.
We need someone to:
- create initial SQL 2012 database with same fields as fields in source
- we don't know the exact data type and length of initial fields
- database codepage must be WIN1250
- data from all source files must be imported to newly created database
First option is to create new database (with the same structure / fields) for each year.
Another option is to create 1 database, with new table (with the same structure / fields) for each year.
A final result should be a database files (for example bak files), which could be easy to import to our SQL 2012 server.