dbTalk Databases Forums  

SSIS: Copy entire schema to another schema within same DB

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS: Copy entire schema to another schema within same DB in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
bnemetchek
 
Posts: n/a

Default SSIS: Copy entire schema to another schema within same DB - 10-30-2006 , 04:01 PM






We have an application that is copying an entire schema (ie, bob) to another
one (ie. frank) within the same DB. Currently, this is done via client
software, but it is naturally very slow because of the bandwidth required. I
cannot determine a method to perform this task, via an SSIS process, running
entirely on the server, that would do this. Is is possible?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.