May 25, 2006 at 8:23 am
Hello!
I have been using SSIS for various tasks for a while and have managed to make life much easier for myself when importing/exporting and manipulating data from various sources.
However... I can't seem to get over one very simple probelm...
If I want to copy an SQL database from one instance to another, using the Transfer Database Task, it will always fail becuase it can not determine the order in which to transfer the objects so as to cater for any dependencies (on views, SPs and functions). Not sure why it needs to do this when I am copying the complete database, but there you go.
Now I am sure that lots of you will want to question my logic for wanting to transfer a database using SSIS, so LETS ASSUME that the only option I have to copy a database is SSIS, and that I must do this while the database is online and I would like to use the Transfer Database Task.
Can anyone enlighten me as to how I tell it to ignore dependencies during the transfer, or to specify that it uses the dependencies without me having to manually setup the transfer for all the individual objects?
Thanks in advance.
May 31, 2006 at 9:08 am
I too had this problem but overcame it using the sequence container. I transferred the master tables first and then the child tables. However, I am not sure if the above could be done with transfer database.
Marvin Dillard
Senior Consultant
Claraview Inc
May 31, 2006 at 10:14 am
Thanks Marvin, I will have a look at the sequence container and see if it can offer some assistance!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply