Backing up a single table with its data from a database and restoring it on different database

Step 1: Choose the database and its table for which you want to take the table backup. (In my example: I use database Kiran and table dbo.Customer)

Step 2: Next, right click on the database and select tasks ->Generate Scripts option.

Step 3: Generate and publish script dialogue box will pop up, now click next.

Step 4: Next, checkbox the particular table for which you want to take the backup then click next. (In my example: I used dbo.Customer table for the backup)

Step 5: Next, scripting options dialogue box will pop up, now click on the advanced button and scroll down to the ‘Types of data to script’ option and choose scheme and data option , then click ok.

^{Types of data to script option}

Step 6: Review, the summary and click next.

Step 7: Next , click on finish to complete the wizard.

Step 8: Now, modify the database name on the script “use [database name]“ where you want to restore the backed-up table and then execute the command.(In my example: I restored the table on database Geopits_demo)

Step 9: Finally, check whether the selected table had restored to the chosen database. (In my example: The table customer have been successfully restored on Geopits_demo database)

Further reading:

If you found this article helpful, you might want to check out these related resources,

• Top 7 factors to look for in Managed DBA service provider
• Top 5 New Features of SQL Server 2023
• 7 Ways To Migrate On-Premise SQL Database To Azure