Data synchronization

[mukesh mr03]

I have an asp.net application hosted in localhost with backend as sql express. An sql server 2008 database with same structure is hosted in a remote server. I have to synchronize these two databases. What is the best way to do this? Can I do it with sync framework? Please suggest me a solution for this.

[R Giskard Reventlov]

How about Backup the remote server and Restore it to the local? Or you could export the data from the remote server and import it back in locally - there are a number of ways to accomplish that. There are a number of other ways that also come to mind but those are probably the easiest and quickest (depending n the size and disposition of the databases).

Tychotics: take us back to the moon "Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars." H. G. Wells

[mukesh mr03]

The process should work in every 1 or 2 hours. The synchronization process should be done automatically. The backup and restore will be difficult in this situation and it will take more time. Is there any other solution apart from back up and restore.

[R Giskard Reventlov]

Well it was good that you mentioned everything in the first post otherwise I might have posted an innapropriate answer. How about scheduling a Sql job that will do the work for you? Sql Server Jobs[^]

Tychotics: take us back to the moon "Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars." H. G. Wells

[mukesh mr03]

Actually I do not know much about sql job. I will try it. Thank you so much for giving the details. If you have any other ideas please give that one too. I'm going to check with jobs. Once again thank you.