Hi,
I have specific request here: I need to copy large
database from one server to another. It has 700GB. Most of
it are indexes (500GB). Because of time restrictions, I
plan to use DTS export to copy ONLY TABLES from this
database (I will create indexes on destination server
afterwards).
Is there any way to do that (wizard doesn't offer option
to exclude indexes)? I hope that there is some way other
than to create transformation for every single table?
Thanks,
OJ

Why do you not use BACKUP and RESTORE? That would be quicker I think.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"OJ" <anonymous (AT) discussions (DOT) microsoft.com> wrote

No, it wouldn't. Problem is in network component of this
process. So we calculated that the fastest way is to
transfer only data, and to create indexes afterwards.
OJ

It may be quicker to move the data but to have accumulated 500GB in Index
space will take some time to reapply surely.

I will go with what metrics you have as I have no experience with index
space of 500GB where the data is only 200GB

If you must do it your way then simply

Use the wizard to generate the DataPump tasks.
Run those

You will now have data on the destination with no indices.

Script the indices on your source to a text file.

Carry the file to the new server and apply (Or get your index creation
scripts out of whatever source control system you use.)


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"OJ" <anonymous (AT) discussions (DOT) microsoft.com> wrote

OJ,

Are you sure the 500GB does not include the clustered indexes? You have to
count that much data whether you have the index or not as it is mainly the
data itself. I still say SQL LiteSpeed will get you a smaller file and with
a lot less effort than what your seeking with DTS.

--
Andrew J. Kelly SQL MVP


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

you can create an empty database on the destination server withtout any
index (you can very easely create an SQL script which do this for you)
Also, create another script which contain only your indexes definition.

then use DTS to load the data from the source to the destination
at the end of the step, execute the script which contain your indexes.

what is the fillfactor of your indexes? try to setup to 100%, maybe you'll
reduce the index file size


"OJ" <anonymous (AT) discussions (DOT) microsoft.com> a écrit dans le message de news:
023701c496a4$b4dd4720$a401280a (AT) phx (DOT) gbl...