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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-13 : 19:29:31
|
| Bill Dodd writes "My business uses an AS/400 for storage of data and some terminal apps. I wish to expose that data more efficiently to the web and some of our PC reports apps, etc. In the past we've read directly from the AS/400 using IBM's client access and their OLEDB provider. ( Which is slow, flaky, spastic and isn't worth it's weight in pesos.) We now have Host Integration Server 2000's MS OleDb Db2 provider. With the grace of god, luck of the irish, and a few lucky guesses I actually got that provder talking with our 400 and it seems to suck the data down pretty quickly. I can do DTS scheduled events, to get the data into the SQL, and that seems to work pretty well. But, the data is several gigs and I'd really like to get away from the batch snapshot of nightly data. ( plus, copying that many tables everynight, increase network traffic, blah blah blah ) So, I figured replication would be a good way to go, after all that's what replication is for, right?! Thus far I haven't seen a way to make SQL a subscriber to a heterogenous data source such as the 400. I've seen a few sketchy articles on setting up the SQL for third party distributership but it really wasn't much help to actually make this work. Do you have any recommendations, links, devine wisdom or folk lore that may shed some light on this grim task? Thanks so much in advance,Bill" |
|
|
|
|
|
|
|
Replication from AS/400 DB2 to SQL2k How?