1

We have requirement of mirroring the database with some fixed set of tables. We do not want to use sql server replication for that purpose.

Do we have any solution for that or any software for this purpose which we can use for the replication of the set of tables to remote location?

We have some set of tables around 6 to 7 that needs to be replicated in remote location so that we can have offline website setup when our live system went down. Which only shows important bit of information online for temporary purpose.

Improve this question
2
  • Hi, Welcome to the site. Please add as much detail into your question as possible. Questions arise such as: What's the reasoning behind this? Why don't you want to use replication? What is the connection between the servers (wan/lan?). What is the use case?
    – Tom V
    Commented Dec 11, 2015 at 8:01
  • Hi Tom, We have some set of tables around 6 to 7 that needs to be replicated in remote location so that we can have offline website setup when our live system went down. Which only shows important bit of information online for temporary purpose.
    – Manish Pansiniya
    Commented Dec 11, 2015 at 8:11

2 Answers 2

Reset to default
4

IMHO, Replication is your best choice.

Alternatively, you can look into SSIS and do an incremental load to your remote database for the tables you need. If they have foreign key dependencies then make sure to load them in order.

Also, you can look into logshipping (this is entire database) and delay the restore of transaction logs, so that you can use secondary as stand by for running reports as well.

Improve this answer
2

Use Replication. It does exactly what you need.

Improve this answer
2
  • Yes, But I dont want to go dipper into replication if we can replicate 5-6 tables easily
    – Manish Pansiniya
    Commented Dec 11, 2015 at 12:51
  • The easiest way to replicate 5-6 tables is using Replication.
    – Remus Rusanu
    Commented Dec 11, 2015 at 13:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.