InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 00:05:43 GMT20http://www.sqlservercentral.com/Forums/Topic421958-149-1.aspxYou must first define the way you will capture the changes in the LIVE_DB.What is the retention policy of this,you can partition your data by datetime and have a full load to the rep_dbor can have logical deletion in REP_DBAgain, the question is what means you will use to detect the changes?If you want to go with logical deletion use SCD techniques , also you need the changes capyture abiity.It can be done through audit, triggers , row version etc..Fri, 12 Oct 2012 15:44:17 GMTdiaz.bernabehttp://www.sqlservercentral.com/Forums/Topic421958-149-1.aspx[quote][b]Michael Earl (11/14/2007)[/b][hr]Assuming you have a primary key (or some unique key that cannot be changed on a record) you can do this very easily.Look at the SCD wizard.Yes, it is true that you are not updating a dimension, but the wizard will walk you through exactly what you are proposing.[/quote]Hi i got 60 sql servers i would like to find version of sql server and service from one server to all servers how can i do that ?Tue, 20 Nov 2007 10:41:16 GMTa.prasad77http://www.sqlservercentral.com/Forums/Topic421958-149-1.aspxAssuming you have a primary key (or some unique key that cannot be changed on a record) you can do this very easily.Look at the SCD wizard.Yes, it is true that you are not updating a dimension, but the wizard will walk you through exactly what you are proposing.Wed, 14 Nov 2007 05:46:13 GMTMichael Earl-395764http://www.sqlservercentral.com/Forums/Topic421958-149-1.aspxCan anyone help regarding the SQL server integration Services(SSIS), ETLWe have requirement like this:We have Live Database( LIVE_DB ) and Reports Database (REP_DB)I want to trasfer the few tables data from LIVE_DB into the REP_DB for end of the day using SSISIf any new records are added, updated or deleted in LIVE_DB, these should reflect in the REP_DB, Our requirement is not to delete the old data, we should append or delete or insert the new transaction data in REP_DB.Thanks in advance, if anyone help me in resolving this issue.Regards,Bhushanam.Wed, 14 Nov 2007 01:34:46 GMTtrbhushanam