Table transfer

#31

Thanks for your help.
Pingx
"Russell Fields" wrote:

Quote:

Ping,

Not really. As you noted, the transfer wizard will create the table, but it
does not go further. That is what scripts are for.

RLF

"Pingx" <Pingx (AT) discussions (DOT) microsoft.com> wrote in message
news:92ADCEEE-7B1B-4EDE-866D-164881244C83 (AT) microsoft (DOT) com...
So there is no way to transfer a table (data/index/constraint/triggers) in
one step?

#32

Thanks for your help.
Pingx
"Russell Fields" wrote:

Quote:

Ping,

Not really. As you noted, the transfer wizard will create the table, but it
does not go further. That is what scripts are for.

RLF

"Pingx" <Pingx (AT) discussions (DOT) microsoft.com> wrote in message
news:92ADCEEE-7B1B-4EDE-866D-164881244C83 (AT) microsoft (DOT) com...
So there is no way to transfer a table (data/index/constraint/triggers) in
one step?

#33

Thanks for your help.
Pingx
"Russell Fields" wrote:

Quote:

Ping,

Not really. As you noted, the transfer wizard will create the table, but it
does not go further. That is what scripts are for.

RLF

"Pingx" <Pingx (AT) discussions (DOT) microsoft.com> wrote in message
news:92ADCEEE-7B1B-4EDE-866D-164881244C83 (AT) microsoft (DOT) com...
So there is no way to transfer a table (data/index/constraint/triggers) in
one step?

#34

Try http://www.sqlscripter.com to transfer your data.

"Pingx" wrote:

Quote:

Hi SQL Server experts:

I'd like to transfer a table from one db to another. The export only
transfer data, not index, constrain or triggers. Is there another tool I can
use besides backup/restore the whole DB?

Thanks in adbance.

Ping

#35

Try to use "select into" with a fully qualified destination. But
remember that the destination table has to be empty or truncated in
order for "select into" to work also make sure the servers have no
firewall in between that will stop this process.

Wisord

*** Sent via Developersdex http://www.developersdex.com ***

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Table transfer

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Table transfer - 09-16-2008 , 06:48 PM

Re: Table transfer - 09-16-2008 , 06:48 PM

Re: Table transfer - 09-16-2008 , 06:48 PM

RE: Table transfer - 07-25-2009 , 08:16 AM

Re: Table transfer - 07-29-2009 , 12:53 PM