Re: dts of everything except indexes...

From: Jéjé (willgart_at_BBBhotmailAAA.com)
Date: 09/10/04

  • Next message: Allan Mitchell: "Re: Dts execution and the public role" 
    Date: Thu, 9 Sep 2004 21:23:42 -0400

    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@discussions.microsoft.com> a écrit dans le message de 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
    >>
    >>
    >>.
    >>

  • Next message: Allan Mitchell: "Re: Dts execution and the public role"

    Relevant Pages

    • Re: Copy Tables
      ... Keep in mind that you can issue a WHERE clause to filter the results to include the rows that you want. ... you can automate script generation using the SQLDMO API. ... >> backed up to an sql script, then i want to restore the database from the ... >> other server, then i want to reload the sql script with the veiws in it, how ...
      (microsoft.public.sqlserver.setup)
    • Re: convert to stored procedure + NDS
      ... Is there a clever way or an existing script I ... can use to find/replace multiple DDL statements in each sql script ... statements into stored procedures so I don't have to manually do so. ...
      (comp.databases.oracle.tools)
    • Re: Copy Tables
      ... my boss is creating new views on a daily basis, so in my case, they aren't ... you can automate script generation using the SQLDMO API. ... >> backed up to an sql script, then i want to restore the database from the ...
      (microsoft.public.sqlserver.setup)
    • Re: PUBLIC Role - What am I missing?
      ... you can make it less painful by using the EM and "Generating SQL Script" ... Check "Script database users and database roles" on the options panel ... After generating the SQL script file then extract all the grants and denies ...
      (microsoft.public.sqlserver.security)
    • Re: Good Scripting Resource
      ... Thanks for the resource. ... Erin ... > I am creating a new SQL Script web site. ... I've restructured the script I was using it in and it has ...
      (microsoft.public.sqlserver.programming)
    Loading