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 - 2006-04-18 : 10:59:59
|
| Scotty writes "Hey guys,Just upgraded from SQL 2000 to SQL 2005.What i have is a AS/400 running the main business system on DB2 tables. I would like to replicate the data from the As/400 to SQL every 2 hours.. In SQL 2000, i had to do overnight data updates as i had a DTS package clearing tables and doing entire data dumps over night for around 30 tables. # of records would exceed 10 million..What is the best way and how do i setup some sort of replication between the As/400 to SQL 2005.. Any help would be great...ThanksScotty" |
|
|
Krankensteins
Starting Member
24 Posts |
Posted - 2006-04-18 : 13:36:53
|
| Did DB2 have replication service? If so, then posible it works like as SQL replication. Then you can get real time synchronization ?!? One of algorithms is add in each table field of type time and on eny changes in tables fire triger or samthing like as thet who change time. Afther that just teik rows with thet times whats you need. (On large amount of WRITE transactions thet is not good idea). |
 |
|
|
|
|
|
AS/400 to SQL 2005