Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ZafarYousafi
Starting Member
2 Posts |
 Posted - 2009-09-08 : 00:27:26
|
| Hi, I want to move large data(50,000+ documents saved in image column) from one sql server to another. I have created an SSIS package to move data. Problem is, My Package is running very slowly. I have tweaked the package but it still taking lot of time. My question is, Is it better to use SSIS for such tasks. Or a direct insert query (SELECT from one server and insert into other) is a good option |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-08 : 01:32:07
|
I have made the experience in many interfaces that insert / select via linked server is much faster.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
ZafarYousafi
Starting Member
2 Posts |
Posted - 2009-09-08 : 07:06:44
|
| You might be right but In my case, DB becomes unstable when I execute query to transfer the data. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-08 : 07:35:15
|
And what's about taking a backup, restore to the other server under a different name and then query your documents?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-09-08 : 16:49:21
|
| I did something like this before using SSIS but I have to do it in batches...Give it a try.http://www.sqlserver007.com |
|
|
|
|
|
|
Transfer Huge Data