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 |
|
dipteshbose
Starting Member
1 Post |
 Posted - 2008-02-06 : 14:12:43
|
| Scenario:I have a INFORMIX Server. At any point of time it has 46,00,000 record, which is equivalent to last 2 month's data.I also have a SQL Server (2000) Ent. Edition. What I have done is that I have created a ODBC (open Link) for INFORMIX. Using that I have copied all the data to the SQL Server. As I have mentioned earlier, INFORMIX stores only last 2 month's data. It deletes all the old data.What I want is that a mechanism of replicating the "differential" data on an incremental basis on the SQL Server. This SQL server data would be used to report out company metrics.Le me know if anyone has been in a similar situation and have the fix ready! I am in real hurry as the project has reached its deadline. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-07 : 00:42:48
|
| Pull new rows via linked server (or your open link). |
 |
|
|
|
|
|
Automated Sync of data between INFORMIX and SQL