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/
Here is an example in which for each chromosome I present the most common three alleles:
I hope that you will find the utility as useful.
Tnx,
Uri Kartoun
http://kartoun.wix.com/info