Technical question

[r]

Hello all.
I have a application that uses a sqlserver database in network..
but sometimes network get disconnected and I don't have access to that
databases..
then I want to use that database in local and then after connecting to
network merge those changes that were made in local
how can I implement this?.Is there a simpler way to meet this problem??
thanks in advance

[=?Utf-8?B?TW9ydGVuIFdlbm5ldmlrIFtDIyBNVlBd?=]

RE: Technical question


"r" wrote:

Hello all.
I have a application that uses a sqlserver database in network..
but sometimes network get disconnected and I don't have access to that
databases..
then I want to use that database in local and then after connecting to
network merge those changes that were made in local
how can I implement this?.Is there a simpler way to meet this problem??
thanks in advance
>
>

Hi r,

This is more of an SQL question than C# and you will most likely get better
answers in an SQL group. I believe what you need is SQL Server Replication.
There are different types of replication and I suggest you ask in an SQL
group which kind is best suited for your needs (or read up and decide for
yourself).

These articles may give you an overview and a few tips.

[Setting Up Merge Replication: A Step-by-step Guide]
http://www.databasejournal.com/featu...le.php/1438231

[SQL Server Replication]
http://msdn.microsoft.com/en-us/library/ms151198.aspx

--
Happy Coding!
Morten Wennevik [C# MVP]