Backup and Restore data of Sql database based on primary Key records in vb.net

See more:

SQL-Server

table

export

backup

, +

I want to implement Backup and Restore functionality for the user where they can take Backup of Certain data from the certain table and then they can restore it. I am working in desktop application in vb.net.

Give you a scenario I have One Company Table in that Company id is primary Key and it is used as foreign key in other tables (around 40 tables)
I want to take backup Company wise (in this case Company id wise say if company id = 1 then need data from all the tables where company id is associated with as foreign key) and then restore those data again when user needed.

So I wanted to know that what is the best option to do this ? I also have performance concern also if data is to large then through which option we can go with? Kindly give your input in this.

Note: I read some article that we can do with xml , csv, through script and also I don’t know through other option we can do this.