I want to get a backup of a single table with its data from a database in SQL Server using a script.
How can I do that?
Advertisement
Answer
There are many ways you can take back of table.
- BCP (BULK COPY PROGRAM)
- Generate Table Script with data
- Make a copy of table using SELECT INTO, example here
- SAVE Table Data Directly in a Flat file
- Export Data using SSIS to any destination