Does DTS import index from another database?

#1

Hello Experts,

I am not good at SQL Server. Would you do me a favor?

If I use DTS Wizard to import data (both source and destination databases
are located in the same database server) and the destination does not
contain any tables, does the DTS Wizard copy the index from the source
database?

Thanks a lot.

Sa

#2

You need to use the option to copy objects and data between
SQL Server databases and then make the indexes are included
in the Options.

-Sue

On Wed, 9 Mar 2005 18:05:28 +0800, "Sa" <ksadf (AT) sdkaew (DOT) org>
wrote:

Quote:

Hello Experts,

I am not good at SQL Server. Would you do me a favor?

If I use DTS Wizard to import data (both source and destination databases
are located in the same database server) and the destination does not
contain any tables, does the DTS Wizard copy the index from the source
database?

Thanks a lot.

Sa

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

Does DTS import index from another database?

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

Does DTS import index from another database? - 03-09-2005 , 04:05 AM

Re: Does DTS import index from another database? - 03-09-2005 , 06:56 AM