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 |
|
MencitPutih
Starting Member
4 Posts |
 Posted - 2008-02-04 : 04:23:06
|
Hello all  ,First of all, i want to give a brief overview what i'm trying to do. We have 2 servers AS/400 and SQL, our AS/400 capacity is already reached it's limit (but our SQL server still have large capacities), so my supervisor ask me to 'remove' old-and-rarely-used data from as/400 to SQL so it will free up some space in AS/400.So the scenario is, first we will determine the criteria of the old-and-rarely-used data, and transfer the data by job (that run DTS) overnight, we will run this job for certain period (once a day/week/month).In daily basis (we use AS/400), if we searched for particular data and unable to find it in AS/400, we will search in SQL and transfer the data back to AS/400 (approximately, max 1000-2000 rows, 60 columns each).What i want to ask is, which one better to transfer data back from SQL to AS/400, DTS or Linked Server (use openquery) or there's any better way? My concern is the transfer speed, we need to transfer the old-and-rarely-used data as soon as possible.PS: I'm using SQL Server 2000Thanks a lot,Ricky |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-04 : 23:16:13
|
| You have to benchmark both to see which one works better for you. |
 |
|
|
MencitPutih
Starting Member
4 Posts |
Posted - 2008-02-05 : 03:43:05
|
Thanks for the reply rmiao  Is there's any better/faster way to transfer data from sql to as/400 back and forth? (other than DTS and linked server?)Btw, I'll be creating application to do this job for me  Thanks for the attention |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-05 : 22:53:53
|
| Maybe bcp out data from sql table. ftp them to as/400 and load them. |
|
|
|
|
|
|
|
|
Dts or linked server? or else?