Import/Export data from csv vs SQL Server

Question

Import/Export data from csv vs SQL Server

SQL*

SSCertifiable

Points: 6638
More actions
July 9, 2012 at 6:54 am

#258573

Hi All,
which is the best option, whether to load data from csv or from the sql server table.
I have export the data from sql to any staging like csv/sql server and again load that data from csv/sql server to sql server. What is the best performance option, whether to export data to csv/sql and import that data to sql server.
CSV or SQL Server table.
🙂

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

Worth a test, though I would expect SQL to SQL to be the fastest.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

SQL* (7/9/2012)
Hi All,
which is the best option, whether to load data from csv or from the sql server table.
I have export the data from sql to any staging like csv/sql server and again load that data from csv/sql server to sql server. What is the best performance option, whether to export data to csv/sql and import that data to sql server.
CSV or SQL Server table.

If it's just dumping the data and read it back out again, RAW files are the best. (proprietary SSIS file format).

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Mike Palecek SSCommitted Points: 1560 More actions · Answer 3

I am looking for the same information. I have two servers that are at different companies and I need to move data from one to another. The servers are both behind firewalls. My first thought was to use a CSV but I was looking for other recommendations when I came across this post.

I am not familiar with a RAW data format and I cannot find anything like that in SSIS 2005. How is this raw format used?

Edit: I guess I should have looked around a little while longer. I found this post a few pages back that really helped. http://www.sqlservercentral.com/Forums/Topic1325992-148-1.aspx

Phil Parkin SSC Guru Points: 246960 More actions · Answer 4

Mike Palecek (7/11/2012)
I am looking for the same information. I have two servers that are at different companies and I need to move data from one to another. The servers are both behind firewalls. My first thought was to use a CSV but I was looking for other recommendations when I came across this post.
I am not familiar with a RAW data format and I cannot find anything like that in SSIS 2005. How is this raw format used?

Have a look here[/url].

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Mike Palecek SSCommitted Points: 1560 More actions · Answer 5

Awesome... thank you. I actually just found a post a few pages back that linked to the same article, VERY useful