sql - Copying database from one computer to another -

sql - Copying database from one computer to another -

me , friend both have sql server 2012. have database re-create on of tables database on friends laptop. not sure not sure how go doing this?

i know in sql server can re-create on info 1 table in database database b using line below.

select * database_a.dbo.mytable database_a.dbo.mytable

what best way connect 2 laptops?

there 2 main options, 1 back database , send friend. right click on database, tasks , backup. problem approach if you're running different versions may have issues.

the alternative script database. right on database, click tasks , generate scripts. create sure take script info , schema advanced options.

the latter preferred approach (as it's much more editable , human readable).

sql sql-server sql-server-2012