DTS: Copy Objects Task

  • bmsjr

    Ten Centuries

    Points: 1199

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bszabo/dtscopy


    Bruce Szabo, MCSE+I, MCDBA, MCSD

  • Andy B.

    SSC Eights!

    Points: 890

    The pictures that are showing are for a Transform Data Task, not Copy DB Objects...  Some of the picts aren't loading either.

    May want to clean that up before the morning.


    Enjoy!

    A Brown

    Manage all of your backups in one simple job using this script.

  • Marie Wilkinson

    SSC Enthusiast

    Points: 178

    I got totally confused because the pictures didn't match the text but I'm new enough to DTS I thought the explanation was too confusing not that the pics didn't apply.  Glad I posted, hope to see this article with the right pictures. Always nice to avoid pitfalls

    Marie

  • John E. McCormick

    SSC Enthusiast

    Points: 126

    May have lots of great information, however the viewing of the article was not checked before release, it seems.  PLEASE, PLEASE Try again.

  • Terrie

    Ten Centuries

    Points: 1353

    I just used the Copy SQL Objects Task this morning and it worked fine except I didn't have the logins set up on the new server.  Duh!  It copied tables, views, sp's and roles.  Fill factors for indexes were there too!  The task I used doesn't look anything like the picture I saw in your article.

    Terrie

  • Andy B.

    SSC Eights!

    Points: 890

    Terrie, be careful when copying views in this manner.

    If you are copying a view from one database to another, and the tables (and data) already exist in the destination, then copying the view with data will replace the data in the tables in your destination with the data from your source.  If you specify to not copy the data, then the rows in the tables in your destination that the view will reference will be deleted.

     

    Confusing? yes.

    Instead, execute the script generated in the properties of the view (from your source) on the destination.


    Enjoy!

    A Brown

    Manage all of your backups in one simple job using this script.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply