Export and import selected rows in the database

Question

Say I have a database like this:

Users
-----
ID int PK Identity
Name vchar(max)

Sales
-----
UserID int FK
Description vchar(max)

And some data:

Users
1, "Daniel"
2, "Barnie"
3, "Frank"

Sales
2, "New computer"
2, "Rubber duck"
3, "Cabbage"

There are also several other tables that reference this primary key. Now there is a requirement that only some users want to get a backup, for example, I want to export data and all related data for users 2 and 3.

: 1) .bak, ? , . 2) .bak , ? csv INSERT sql script, . , , . ? filestreaming , , .

. SQL Server 2008.

Answer 1

: 1) .bak, ? , .

. SQL Server .

2) .bak , ?

, , . ( , ).

, .

csv INSERT sql script, . , , . ? filestreaming , , .

? , , . , .

Answer 2

, , , ( ). , , , .

Answer 3

. , /.

. , , . , , !

Answer 4

, . , , .

Answer 5

:

• , .
• ( , )
• ( ), .
• insert ignore.

, :)

Answer 6

:

• ,

Filestream, , .csv bcp . , , .

• DbName.

DbName , . . .

• , (, , ).

, SQL, . .

Answer 7

- SSIS . , , . , , .