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 - 2005-09-26 : 07:54:30
|
| Subir Majumdar writes "Hi,I have a requirement for one of my clients. The requirement is to replicate data from AS400 to SQL server. The table structures on both the systems are a bit different, but if required, I can create an exact copy on either systems.The requirements are as follows:1. As soon as the AS400 table gets updated, it has to update the SQL table. It has to happen realtime, so DTS and other batch methods are out.2. I dont know java, so I was thinking of configuring the SQL server as a remote database on the AS400 and access it using a RPG trigger on the DB2/400 table. But I have been unsuccessful. any suggestions?Thanks in advance,Subir Majumdar" |
|
|
|
|
|
Replication of data from AS400 to SQL Server