Programming for synchronization of local database with remote server database.

[Digubha]

Hii everybody, i am developing window application in c# and .net and i want to know that how to write a join query for update of local database by the content of remote server database!. Scenario :- Suppose there is one database say softbuyweb at local machine and other database softbuyweb1 at remote server. now there is table in softbuyweb say product and similarly there is table in softbuyweb1 say product1 now both the table product and product1 in database softbuyweb and softbuyweb1 respectively has same column/field name, datatype and length of datatype. now i want that in my window form i place one button say "Update" on its click event there should be query which fires and the total content of table product1 at remote server is copied and the content of table product at local machine is updated with that copied content. i think it is little confusing and also it may be difficult to write single sql query for two different data sorce connection and it might create ambiguity because both connection are establishes in a single block of code. now , please help me on this topic , and please response as qick as possible! my database is in sql server 2005. thanx in advance. :)

[Ennis Ray Lynch Jr]

The easiest way would be to link the SQL Server databases together so you could use an UPDATE FROM statement(Those things are like magic) Beyond that and using any sort of Database specific synchronization open a cursor, compare records, and update the outdated db.

Need custom software developed? I do C# development and consulting all over the United States.
If you don't ask questions the answers won't stand in your way.
Doing a job is like selecting a mule, you can't choose just the front half xor the back half so when you ask me to do a job don't expect me to do it half-assed.

[Mycroft Holmes]

Ennis Ray Lynch, Jr. wrote:

UPDATE FROM

Ennis can you elaborate on this. Is it like the select into shortcut for creating tables? Wondering if I have missed something all these years?

Never underestimate the power of human stupidity RAH

[Ennis Ray Lynch Jr]

UPDATE customer SET customer.firstName = remoteCustomer.firstName FROM customer INNER JOIN remoteCustomer ON remoteCustomer.id = customer.Id AND remoteCustomer.GUID <> customer.GUID;

Need custom software developed? I do C# development and consulting all over the United States.
If you don't ask questions the answers won't stand in your way.
Doing a job is like selecting a mule, you can't choose just the front half xor the back half so when you ask me to do a job don't expect me to do it half-assed.

[Mycroft Holmes]

Thanks Ennis Nothing new there, just thought there might have been something quite different. Sometimes I come across something in the forums completely new in a tool I have been using for ages (eq SQL).

Never underestimate the power of human stupidity RAH