index > Windows Forms Data Controls and Databinding > How to Merge databases

How to Merge databases

hello

Expert

can anybody tell me how to merge Multiple database to a single database?

i have a desktop windows application [front:- C# , Bak-end - Sqlserver 2005]

that are distributed in multple branch & each having different database

my problem is how all branche's database can merge to single database? .

i have try sqlserver 2005 tablediff.exe , but problem is that it delete destination tables's records if source tables records is not match,

thanks

arup

arup08 Tuesday, September 15, 2009 7:31 AM

I'm not sure this is what you are asking, but here is some information on database sync:

http://msdn.microsoft.com/en-us/library/bb384585.aspx

Hope this helps.

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

DeborahK Thursday, September 17, 2009 4:43 AM

You can use google to search for other answers

Custom Search

More Threads

• Databinding: Updating database through Save button on binding navigator toolbar

• Combobox displaymember value reset

• running a stored procedure with multiple select statments by the adapter

• DataGridView

• how to merge headers in a DataGridView

• Any good examples of custom paging with data adapters?

• Slowness in setting bindingsource current row values

• ENTER should behave like TAB in DataGridView

• Handling When BindingSource.EndEdit Raises Exception (Bug?)

• Exception while clearing the DataGridView Data source on a separate thread using Backgroundworker