Data transfers

[Sean McKaharay]

Hey All,

I am trying to write an app that will transfer data from one SQL Server to
another. Here is my situation:
I have 2 computers neither one is connected.
I have the same database on both computers.
I need to update the data at the end of the night to reflect the changes on
the particular database.
So the data collected on computer1 needs to get to computer2 and the data on
computer2 needs to get to computer1.

The question is.....What is the best way to do this?


Thanks ahead of time,
Sean

 

[Nicholas Paldino [.NET/C# MVP]]

Sean,

The best way to do this is actually to use the Data Transformation
Services. It is used to transfer data between two data sources which have
OLE-DB providers for them. You can easily transfer data between two SQL
servers with this.

Check out the section of the MSDN documentation titled "Data
Transformation Services API", located at (watch for line wrap):

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ad_2zjn.asp

This is a COM API, so you will have to use COM interop to access it.

Also, you might want to look into SQL server replication, which you
would access through COM Interop as well, using the SQL DMO library.

Hope this helps.