October 5, 2011 at 2:39 pm
can i use ssis if I want to move data from SQL 2000 to SQL 2008?
October 5, 2011 at 2:44 pm
Yes
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 5, 2011 at 3:05 pm
Sean,
When DTS compared to SSIS, which tool is the best with respect to performance? I was told that DTS performs much better if you are just moving data from source to destination. And also my tables are really huge( few of them are > 400GB)
October 5, 2011 at 3:25 pm
sunny.tjk (10/5/2011)
Sean,When DTS compared to SSIS, which tool is the best with respect to performance? I was told that DTS performs much better if you are just moving data from source to destination. And also my tables are really huge( few of them are > 400GB)
In your case it probably doesn't make much difference. Performance is going to be painful due to the volume of data you need to move. You might consider doing this via t-sql instead. It will give you a little more flexibility given the large datasets you are dealing with. There are a number of threads around here about doing incremental inserts. It will let do this in smaller batches which will give you some freedom to things like wait a little in between each batch so the server can catch up a little bit. Trying to move that much data in a single batch would be devastating to overall performance. The amount of logging would be really large. Let me know if you need some help with setting up your batches and I will dig up one of those threads. I could probably regurgitate it but it wouldn't be as easy to understand as some of the ones I have read on here recently.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 5, 2011 at 3:59 pm
sunny.tjk (10/5/2011)
Sean,When DTS compared to SSIS, which tool is the best with respect to performance? I was told that DTS performs much better if you are just moving data from source to destination. And also my tables are really huge( few of them are > 400GB)
First, I loved DTS, but i had to manipulate the crap of of the object model to do some of the things I wanted to do, with SSIS I rarely have to get too freaky. But DTS was depracated in 2005, it is carried as a backwards compatibility option and cannot be counted on being available. Also, I can't remember but I think Denali dropped DTS entirely, YMMV.
I cannot in good conscience recommend developing anything NEW in DTS and DO recommend moving what you have into SSIS.
With all that said, there are places and situations that DTS can outperform SSIS but it is not enough to get me to develop new code in a technology that is effectively dead and guarantee I will have to upgrade in the future..
CEWII
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply