Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTS: Copy Objects Task Expand / Collapse
Author
Message
Posted Monday, October 4, 2004 5:54 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 12, 2009 9:06 AM
Points: 171, 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
Post #139958
Posted Tuesday, October 12, 2004 8:45 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 1:33 PM
Points: 162, Visits: 66

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.
Post #141415
Posted Wednesday, October 13, 2004 6:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 7:18 AM
Points: 44, 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

Post #141476
Posted Wednesday, October 13, 2004 7:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 2, 2005 10:59 AM
Points: 106, 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.
Post #141500
Posted Wednesday, October 13, 2004 2:22 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 7:25 AM
Points: 114, Visits: 593

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




Post #141591
Posted Wednesday, October 13, 2004 3:08 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 1:33 PM
Points: 162, Visits: 66

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.
Post #141602
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse