Mark Forums Read

Table transfer

Go Back

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

Reply

Page 1 of 4

1

#1

Old

Pingx

Posts: n/a

Table transfer - 09-16-2008 , 12:23 PM

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

Reply With Quote

#2

Old

Russell Fields

Posts: n/a

Re: Table transfer - 09-16-2008 , 04:28 PM

Ping,

Using Management Studio (2005) or Enterprise Manager (2000), right click on
the database you want and choose Tasks ... (or All Task... ) script. The
choose the generate scripts task and answer the dialogs to get the things
you want generated. Run the resulting script on the other server to create
tables, indexes, triggers, etc.

Or, if you just want one, rather simple table:

Using Management Studio (2005) or Query Analyzer (2000), expand the
database, Tables noe, right click on the table you want and choose a CREATE
script. Then expand the indexes node, right click on each index and choose
a CREATE script. Ditto for trigger, etc.

Put these all together and run it on the other server.

RLF

"Pingx" <Pingx (AT) discussions (DOT) microsoft.com> 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

Reply With Quote

#3

Old

Russell Fields

Posts: n/a

Re: Table transfer - 09-16-2008 , 04:28 PM

Ping,

Using Management Studio (2005) or Enterprise Manager (2000), right click on
the database you want and choose Tasks ... (or All Task... ) script. The
choose the generate scripts task and answer the dialogs to get the things
you want generated. Run the resulting script on the other server to create
tables, indexes, triggers, etc.

Or, if you just want one, rather simple table:

Using Management Studio (2005) or Query Analyzer (2000), expand the
database, Tables noe, right click on the table you want and choose a CREATE
script. Then expand the indexes node, right click on each index and choose
a CREATE script. Ditto for trigger, etc.

Put these all together and run it on the other server.

RLF

"Pingx" <Pingx (AT) discussions (DOT) microsoft.com> 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

Reply With Quote

#4

Old

Russell Fields

Posts: n/a

Re: Table transfer - 09-16-2008 , 04:28 PM

Ping,

Using Management Studio (2005) or Enterprise Manager (2000), right click on
the database you want and choose Tasks ... (or All Task... ) script. The
choose the generate scripts task and answer the dialogs to get the things
you want generated. Run the resulting script on the other server to create
tables, indexes, triggers, etc.

Or, if you just want one, rather simple table:

Using Management Studio (2005) or Query Analyzer (2000), expand the
database, Tables noe, right click on the table you want and choose a CREATE
script. Then expand the indexes node, right click on each index and choose
a CREATE script. Ditto for trigger, etc.

Put these all together and run it on the other server.

RLF

"Pingx" <Pingx (AT) discussions (DOT) microsoft.com> 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

Reply With Quote

#5

Old

Russell Fields

Posts: n/a

Re: Table transfer - 09-16-2008 , 04:28 PM

Ping,

Using Management Studio (2005) or Enterprise Manager (2000), right click on
the database you want and choose Tasks ... (or All Task... ) script. The
choose the generate scripts task and answer the dialogs to get the things
you want generated. Run the resulting script on the other server to create
tables, indexes, triggers, etc.

Or, if you just want one, rather simple table:

Using Management Studio (2005) or Query Analyzer (2000), expand the
database, Tables noe, right click on the table you want and choose a CREATE
script. Then expand the indexes node, right click on each index and choose
a CREATE script. Ditto for trigger, etc.

Put these all together and run it on the other server.

RLF

"Pingx" <Pingx (AT) discussions (DOT) microsoft.com> 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

Reply With Quote

#6

Old

Russell Fields

Posts: n/a

Re: Table transfer - 09-16-2008 , 04:28 PM

Ping,

Using Management Studio (2005) or Enterprise Manager (2000), right click on
the database you want and choose Tasks ... (or All Task... ) script. The
choose the generate scripts task and answer the dialogs to get the things
you want generated. Run the resulting script on the other server to create
tables, indexes, triggers, etc.

Or, if you just want one, rather simple table:

Using Management Studio (2005) or Query Analyzer (2000), expand the
database, Tables noe, right click on the table you want and choose a CREATE
script. Then expand the indexes node, right click on each index and choose
a CREATE script. Ditto for trigger, etc.

Put these all together and run it on the other server.

RLF

"Pingx" <Pingx (AT) discussions (DOT) microsoft.com> 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

Reply With Quote

#7

Old

Russell Fields

Posts: n/a

Re: Table transfer - 09-16-2008 , 04:28 PM

Ping,

Using Management Studio (2005) or Enterprise Manager (2000), right click on
the database you want and choose Tasks ... (or All Task... ) script. The
choose the generate scripts task and answer the dialogs to get the things
you want generated. Run the resulting script on the other server to create
tables, indexes, triggers, etc.

Or, if you just want one, rather simple table:

Using Management Studio (2005) or Query Analyzer (2000), expand the
database, Tables noe, right click on the table you want and choose a CREATE
script. Then expand the indexes node, right click on each index and choose
a CREATE script. Ditto for trigger, etc.

Put these all together and run it on the other server.

RLF

"Pingx" <Pingx (AT) discussions (DOT) microsoft.com> 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

Reply With Quote

#8

Old

Russell Fields

Posts: n/a

Re: Table transfer - 09-16-2008 , 04:28 PM

Ping,

Using Management Studio (2005) or Enterprise Manager (2000), right click on
the database you want and choose Tasks ... (or All Task... ) script. The
choose the generate scripts task and answer the dialogs to get the things
you want generated. Run the resulting script on the other server to create
tables, indexes, triggers, etc.

Or, if you just want one, rather simple table:

Using Management Studio (2005) or Query Analyzer (2000), expand the
database, Tables noe, right click on the table you want and choose a CREATE
script. Then expand the indexes node, right click on each index and choose
a CREATE script. Ditto for trigger, etc.

Put these all together and run it on the other server.

RLF

"Pingx" <Pingx (AT) discussions (DOT) microsoft.com> 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

Reply With Quote

#9

Old

Russell Fields

Posts: n/a

Re: Table transfer - 09-16-2008 , 04:28 PM

Ping,

Using Management Studio (2005) or Enterprise Manager (2000), right click on
the database you want and choose Tasks ... (or All Task... ) script. The
choose the generate scripts task and answer the dialogs to get the things
you want generated. Run the resulting script on the other server to create
tables, indexes, triggers, etc.

Or, if you just want one, rather simple table:

Using Management Studio (2005) or Query Analyzer (2000), expand the
database, Tables noe, right click on the table you want and choose a CREATE
script. Then expand the indexes node, right click on each index and choose
a CREATE script. Ditto for trigger, etc.

Put these all together and run it on the other server.

RLF

"Pingx" <Pingx (AT) discussions (DOT) microsoft.com> 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

Reply With Quote

#10

Old

Pingx

Posts: n/a

Re: Table transfer - 09-16-2008 , 05:02 PM

So there is no way to transfer a table (data/index/constraint/triggers) in
one step?

Reply With Quote

Reply

Page 1 of 4

1

« Previous Thread | Next Thread »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.