Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 transfer data from on DB to another DB

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-10-18 : 08:08:13
Harald Hora writes "my problem:

I have 2 different dbs. One on the local computer(sql server 2005) and one in the company network(also sql server 2005).

the db on the local computer get every seconds many datasets(maybe up to some 100). When the data logging is over, the datasets should moved(maybe copy and then delete??) to the sql server in the network.

The programm for the datalogging is written in C#, so i must start the moving from the programm.

What is the best solution for this problem??. Everything is possible. I will not use a for loop in C# for this problem. maybe a stored procedure or function on the sql server??

Thanks for your answer
Harald Hora"
   

- Advertisement -