I have a scenario in which one database (DB2) should be updated with the changes that are occurring in (DB1). They are not connected and no connection between the two can occur. Can a script from the transactional log from DB1 be applied against DB2? If so, what is the best way to do create and achieve this? I am looking for some commentary on approach -
Thank you in advance!