January 13, 2009 at 9:08 am
I have an asp.net website hosted on a shared hosting server. There is an offline version of the same website running on my desktop. I need to synchronize the databases of both the applications after every hour. Merge Replication is not supported by the server. I need to know if there is a transact sql or any other method to this. I am using SQL Server 2005.
Thanks in advance
Shoaib Mehmood
IT Consultant
Techweavers
January 13, 2009 at 9:30 am
You could get a SQL Data Comparison product like RedGate SQLDataCompare or ApexSQL's product.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 13, 2009 at 9:39 am
As long as your "changes" are not too big any of the tools above or some scripting with the free "tablediff.exe" will do it!
* Noel
January 13, 2009 at 9:44 am
tablediff.exe is a good idea. I always forget about it. That will just sync data. If you want to sync schemas one of the third-party tools is the way to go.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 13, 2009 at 10:58 am
Good call about the schema changes! I was not considering that the PO could want that but it is entirely possible.
* Noel
January 13, 2009 at 11:17 am
Thanks a lot for your replies. tablediff will do the job but i am not sure if i will be able to run it from inside my application because i need a synchronize button in my application and not run utilities from command prompt. Or if it can be done through transact-sql, that would also be good so that i can just run a stored procedure to do the job.
If tablediff can be used from inside my application, i will really appreciate if someone can provide a sample code.
Thanks once again.
January 13, 2009 at 11:26 am
Follow the link I posted for tablediff or use our good old friend google, there are many articles on the web with examples on how to use tablediff.
From your app your "synchronize" button will simply wrap a call the tablediff.exe executable with the appropriate parameters...
Good luck
* Noel
January 14, 2009 at 1:02 am
Thanks Noel!
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply