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 |
|
rwaldron
Posting Yak Master
131 Posts |
 Posted - 2010-10-13 : 10:54:33
|
| Hi all,I have a table in DB2 that has containtly changing data.This DB is read only so I can't write to the DB2.I have created a table in sql(lets call it tbl_A with the contents of data from DB2 table...However, this is what I'm trying to make happen..When any changes are made to DB2 Table I want to update changes to sql tbl_A... what I meant by changes to DB2 is, if a new line of data is added, if a line of data is deleted,If a line of data is changed.....so I want DB2 table contantly being replicated to SQL.There may also be a need to add records directly to SQL table and so this is where I get lost..!!can someone give me an ideas as to the best way to do this in sql queries or even in SSIS..Thx in advance for any respones.Ray.. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-13 : 10:59:48
|
| if it's read only, how is the data changing?perhaps you just don't have permissions?anyway, can do this with Transactional Replication, or a trigger |
 |
|
|
rwaldron
Posting Yak Master
131 Posts |
Posted - 2010-10-14 : 04:27:42
|
| Hiya Russell,sorry , Its not that DB2 is read only.what I meant to say is that I'm not allowed to write to DB2..Its not our system, Hence the use of the SQL DB.Can you explain a bit more about Transactional Replication, or a trigger please ?Ray.. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
|
|
|
|
|
append any changes from tbl1 to tbl2