Copying tables from one SQL Database to Another



In this video we show how you can copy SQL tables from one SQL database to another.

Transcript

in this video we'll show how you can

copy tables from one sql database to

another sql database so you can see here

we're at the web control panel we'll go

ahead and choose tools

more and then we'll say export from a

sql database

to another sql database so i'm going to

go here and choose

my source database i'll just choose this

database over there

then i'll go and choose my target

database

so i'll choose this database so if we go

and explore the target database we'll

see that there are currently no tables

in the target database

so i'm going to go ahead and i i could

basically say

only export certain tables but i'm going

to go ahead and export all tables and

then go ahead

and click copy and also before i do this

i could create a new database in the

same

server that this connection string is

pointing to

but i'm going to go ahead then just use

the existing database so go ahead and

click

the copy button so this shows me all of

the

tables in my source database and

you can see that as it's doing the copy

it's showing me progress

the table that's currently being copied

is shown in blue

so currently you can see the table that

we're currently copying has 67

000 records and we've now copied all of

them

and when this completes

you'll see that the message at the top

changes to

a done message so you'll see it'll

change pretty soon

so now as copy complete is done so we've

now finished copying all the records

from the source into the target

and if we go here and we explore the

target database

we can now see that basically there are

a whole bunch of tables that have been

copied over

so the ability to copy database tables

from one sql database to another

can be quite useful especially when

you're building test databases thanks

very much