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 |
|
nirkh
Starting Member
3 Posts |
 Posted - 2005-11-17 : 11:11:52
|
| I have an application where i want to replicate specific tables from IBM AS400 DB2 to SQL server 2000 standard. I have no permissions to make any changes to IBM DB2. Is there any way i can replicate the tables in DB2 to SQL server without changing any configuration in DB2? I have full permissions on the those specific tables. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-11-17 : 11:25:52
|
| "poor mans replication??"a) delete data from sqlb) define linked server to db2c) insert into sqltable select * from linkedserver.db2tabled) schedule in SQL according to how 'fresh' the data needs to be. |
 |
|
|
nirkh
Starting Member
3 Posts |
Posted - 2005-11-17 : 12:26:31
|
| Thanks Andrew. Another question - what can be the limit that i can 'refresh' the data. Because i need instant 'fresh' data. thanks again for your help and reply |
|
|
|
mickey
Starting Member
1 Post |
Posted - 2005-11-17 : 17:51:17
|
| i actually have a similar situation. i am building a SQL 2000 application that has to reference some tables on the as400. instead of importing the data from the as400 to sql, the sql tables will just reference the primary key of the tables on the as400.i tested this out in ASP. I opened up 2 ADODB connections and queried the AS400 using the results from my SQL2000 query results. like this, i don't have to have the same data in 2 location, i get to access live AS400 data and don't even have to put it on the as400. in fact, i ran a test and created some tables in a new library on the as400. in another ASP page, i just open one ADODB connection and queried the data in the 2 libraries using an INNER join. I found that the first page with 2 DB connections (sql & as400) was slightly faster than when i had all the data on the as400. |
|
|
|
nirkh
Starting Member
3 Posts |
Posted - 2005-11-17 : 19:15:04
|
| Thanks Mickey. But i have another problem here. The data that replicates in SQL2000 also changes based on the industrial automation process and that data has to be refreshed on AS400 system also. Now i don't have any permission to mess with AS400 configuration, so does it mean that i have to write an application to insert rows in tables in AS400?? The hardest and toughest requirement is that data should be refreshed at every 10-50 ms.Do you have any ideas on how to do that? |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-11-18 : 05:38:55
|
| "...Do you have any ideas on how to do that?".yea! shoot the person who wants data that fast....why not just get them to use the DB2 database direct!...it'd be simpler. |
|
|
|
|
|
|
SQL server to replicate from IBM DB2