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
Customer Support