Post reply

Import/Export data from csv vs SQL Server

  • 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.

    🙂

  • July 9, 2012 at 7:07 am

    #1510316

    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

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • July 10, 2012 at 12:18 am

    #1510689

    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

  • July 11, 2012 at 9:42 am

    #1511644

    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

  • July 11, 2012 at 9:48 am

    #1511656

    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

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • July 11, 2012 at 9:50 am

    #1511657

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

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

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