The FromTSV2SQL utility allows importing TSV files into Microsoft SQL Server 2012, while TSV stands for tab-separated values. The main motivation for me to develop this utility was my attempts to use "SQL Server Import and Export Wizard" to import a large genetics-related flat file (4.7GB). The wizard didn't do a good job in importing such a large file.

The FromTSV2SQL utility requires a bit of manual work (such as creating a SQL table and configuring several parameters) but once configured, it runs smoothly. Don't forget to add an index to your table.

The file I imported contains genetics data including chromosomes and single-nucleotide polymorphism information (SNP) for a one person - take a look: ftp://ftp2.completegenomics.com/

I hope that you will find the utility as useful.

Tnx,

Uri Kartoun