Post reply

how to export and import table single table in databe

  • March 22, 2016 at 9:54 pm

    #399899

    hello,

    I am new to SQL server. can any one please post, how to take backup and restore of particular table in database through GUI in SQL2008.

    thanks,

    Raja

  • March 22, 2016 at 11:07 pm

    #1866988

    There's a bunch of ways. Easiest would be:

    In SQL Server Management Studio right-click the table then navigate to "export" and walk through use the wizard. The most common format/output is to a csv file. You would import files the same way (except navigate to "Import")

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • March 22, 2016 at 11:09 pm

    #1866989

    Since you're new, maybe this won't hurt... watching Grant Fritchey explain it and walk you through it...

  • March 23, 2016 at 3:11 am

    #1867010

    what if the table is in GB size?

  • March 23, 2016 at 8:24 am

    #1867101

    radireddy18 (3/23/2016)

    what if the table is in GB size?

    You'll have to wait for a while. 😀

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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