October 4, 2022 at 1:26 pm
Hello expertise,
Could you please suggest best tool for database replication? data replication on transactional basis and using for filtering option like DELETE transaction not replicate to target database due to data should maintain long term in target database instance.
Thanks.
October 4, 2022 at 3:49 pm
Transactional replication using modified article properties to not replicate delete statements would be the way I would do it.
What are your full requirements for this though?
October 6, 2022 at 10:15 am
Hi.
My requirement is don't want use SQL native replication method instead of using application s/w tool and GUI based for SQL server to SQL server data replication from different sites. please suggest if any best s/w 's tools for database replication.
Thanks.
October 6, 2022 at 1:19 pm
Again use the built-in replication tools.
You will be very hard pressed to do something you want to do better than replication itself that is acceptable to performance.
The only other alternatives are write you own programs which integrate with RMO to do what replication does under the hood.
Put triggers on every single table to build the logic you need to not replicate deletes, then use SSIS to transfer the data/deltas every certain period.
Use things like CDC and / or Change Tracking which again use replication and then again build your own packages to transfer data.
You’re then into ETL territory rather than replication but you may be able to find a suitable ETL tool but you need to do that hard work setting up the triggers/cdc/ct first.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply