Friday, 19 April 2013

Backup a Single Table in SQL Server 2008 using SSMS

For tables that are not very big, you can create a script using SQL Server Management Studio that you can use to recreate the table (and the data in the table):
1. Right-click the database and choose Tasks > Generate Scripts:

2. In the Choose Objects pane, select the table you want to script

3. In the Set Scripting Options pane, click Advanced.

4. In the Types of Data to Script option, choose Schema and Data

Click ‘Next’ through the remaining screens:

…and you will get a script for recreating the table with data.

Posted by at

1 comment:

  1. Unknown9 December 2014 at 11:53

    To export:

    bcp "[MyDatabase].dbo.Customer" out "Customer.bcp" -N -S ServerName -T -E -U"xxxxxx" -P"xxxxxxx"


    To import:

    bcp "[MyDatabase].dbo.Customer" in "Customer.bcp" -N -S ServerName -T -E -b 10000 -U"xxxxxx" -P"xxxxxxx"

    ReplyDelete

Subscribe to: Post Comments (Atom)