SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DTS: Copy Objects Task


DTS: Copy Objects Task

Author
Message
bmsjr
bmsjr
SSC Veteran
SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)

Group: General Forum Members
Points: 289 Visits: 6
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.
Andy B.
SSC-Enthusiastic
SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)

Group: General Forum Members
Points: 190 Visits: 67

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
Marie Wilkinson
Valued Member
Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)

Group: General Forum Members
Points: 52 Visits: 129

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
John E. McCormick
SSC-Enthusiastic
SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)

Group: General Forum Members
Points: 108 Visits: 1
May have lots of great information, however the viewing of the article was not checked before release, it seems. PLEASE, PLEASE Try again.
Terrie
Terrie
SSC-Enthusiastic
SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)

Group: General Forum Members
Points: 174 Visits: 871

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.
Andy B.
SSC-Enthusiastic
SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)

Group: General Forum Members
Points: 190 Visits: 67

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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search