Transfer Tables?

24 Aug 2006 8:21 AM

robken

Hi all,

Does anybody know how you would go about moving tables from 1 database
to another? Say I had table1 and table2 currently stored in
"database1" and I wanted to move them to a new database "database2"
what commands would I use?

Thanks for your help.

24 Aug 2006 8:40 AM

Uri Dimant

robken

DTS

Show quote

"robken" <robin.kenn***@hotmail.co.uk> wrote in message
news:1156407669.985844.13150@i42g2000cwa.googlegroups.com...
> Hi all,
>
> Does anybody know how you would go about moving tables from 1 database
> to another? Say I had table1 and table2 currently stored in
> "database1" and I wanted to move them to a new database "database2"
> what commands would I use?
>
> Thanks for your help.
>

24 Aug 2006 9:29 AM

Tomasz Borawski

or SELECT INTO if this two databases exist on the same sever.

Show quote

"Uri Dimant" wrote:

> robken
>
> DTS
>
>
> "robken" <robin.kenn***@hotmail.co.uk> wrote in message
> news:1156407669.985844.13150@i42g2000cwa.googlegroups.com...
> > Hi all,
> >
> > Does anybody know how you would go about moving tables from 1 database
> > to another? Say I had table1 and table2 currently stored in
> > "database1" and I wanted to move them to a new database "database2"
> > what commands would I use?
> >
> > Thanks for your help.
> >
>
>
>

24 Aug 2006 9:45 AM

Uri Dimant

Tomasz

> or SELECT INTO if this two databases exist on the same sever.

Using the above script SQL Server will not transfer PK,FK as well as
computed columns if they exist

Show quote

"Tomasz Borawski" <TomaszBoraw***@discussions.microsoft.com> wrote in
message news:9CACDAE8-5DF1-4CFE-886F-4D2EEFB12130@microsoft.com...
> or SELECT INTO if this two databases exist on the same sever.
>
> "Uri Dimant" wrote:
>
>> robken
>>
>> DTS
>>
>>
>> "robken" <robin.kenn***@hotmail.co.uk> wrote in message
>> news:1156407669.985844.13150@i42g2000cwa.googlegroups.com...
>> > Hi all,
>> >
>> > Does anybody know how you would go about moving tables from 1 database
>> > to another? Say I had table1 and table2 currently stored in
>> > "database1" and I wanted to move them to a new database "database2"
>> > what commands would I use?
>> >
>> > Thanks for your help.
>> >
>>
>>
>>