June 12, 2009 at 7:23 am
Hello everyone,
Apart from triggers is there option to perform incremetal update between database? Additionaly can we do that from target server?
ta
June 12, 2009 at 3:30 pm
Depending on what you're wanting to do, transactional replication might be what you're looking for.
Randy
June 13, 2009 at 8:12 am
Could you be a bit more specific, please. Which kind of updates? Data/Structure?
June 13, 2009 at 12:31 pm
We need to get updated data. Let me clearly explain my scenario.
Source and target's datamodel are different and that I wrote stored procedure to load bulk data which take care all my conversions. Everynight source database (stag server) gets live update from production server and thats needed to be propagated to my target database.Can trigger be the best option to send update to target server from stag server?
Production server --- sends update to -- stage server (source server)
Stag server --- needs to send only changes(insert/delete/update) to new model (target server)
could we use trigger to send all updates to the new model?
June 13, 2009 at 12:52 pm
Thanks for the explanation. There are two possible ways to go in my opinion:
* If your tables contain something like a TIMESTAMP or a last-updated column you can use an additional table which holds the timestamp/date of the last handled data. So you can write this information in one run and use it at second run to update only changed data.
* The other possibility are trigger which write data or ids of changed rows into staging tables which will be used by your procedure or any other ETL job (like SSIS) to update your destination database.
Flo
June 15, 2009 at 3:52 am
HI Flo,
As there are no time stamp columns on the table , I have considered trigger option. I will using triggers to write information about insert/update/delete to the view which will then be queried by my stored procedure. Thank you for your effort and explanation.
Ta
June 15, 2009 at 3:57 am
Glad we could help! 🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply