Re: dts of everything except indexes...

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 09/10/04 

Date: Thu, 9 Sep 2004 21:14:49 -0400

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@no-spam.sqldts.com> wrote in message
news:enZjIbqlEHA.1672@TK2MSFTNGP14.phx.gbl...
> 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@discussions.microsoft.com> wrote in message
> news:023701c496a4$b4dd4720$a401280a@phx.gbl...
> > 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
> > >-----Original Message-----
> > >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@discussions.microsoft.com> wrote in
> > message
> > >news:8ec101c4968f$ef4e6ac0$a601280a@phx.gbl...
> > >> 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
> > >
> > >
> > >.
> > >
>
>

Relevant Pages

  • Re: importing delimited file into SQL table via c++
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)
  • Re: Incremental changes ODBC via DTS
    ... I had thought that DTS wouldn't be able to tell on ... > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> Ideally I would report directly on the odbc datasource, ...
    (microsoft.public.sqlserver.dts)
  • RE: A couple of R2 Impressions
    ... I agree 110% with Ross M...why why why take away my DTS that I rely and works ... component or I can't use it...it is going to be hard enough to master SQL ... have concern over the decision to dramatically reduce functionality with the ... or good business for MS – it just alienates customers. ...
    (microsoft.public.windows.server.sbs)
  • Re: How do I run a .BAS file saved from a DTS package?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... I have used DTS for import and export. ... > The DTS Designer is easy to understand and use. ...
    (microsoft.public.sqlserver.dts)
  • Re: Sybase Source. What "data flow source" to use?
    ... but could still use DTS to move data. ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)