Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Best Method to make replication between two SQL database?

Databases
user-image
Question added by Mena Adel , Team Lead , Minapharm Company Limited
Date Posted: 2014/07/23
Upvote (1) Views (4) Followers (5) Answers (3) Report Question
Write an Answer
Register now or log in to answer.
Deleted user
by Deleted user

Best Method to make replication between two "SQL database??!!!"

http://www.bayt.com/fr/specialties/q/54931/what-is-the-best-scenario-for-database-backup/

Muktar SayedSaleh
by Muktar SayedSaleh , Software Engineering Manager , AIRASIA

Mirroring

or

sql clustering.

Rami Nasr
by Rami Nasr , Senior Software Developer , MSS (Management Systems and Solutions )

It's depending on the scenario

You can make Snapshot replication to replicate everything it's like a backup,

Merge replication used if you want server and client make changes in the database

Transactional to make one way replication

Write Your Answer
More Questions Like This