Copying data from one server to another.

[UJ]

I need to move specific records from one server to another as part of a
customer upgrade process. What's the easiest way to do this? I could use a
DataTable to get the data and then write out a text insert statement but
that seems pretty cumbersome. Is there some way I could read in the
datatable, change where it points to and then update it?

TIA - Jeff.

 

[Guest]

are you using sql server? if so then perhaps using a DTS (data transform
services) package would be better, especially if you have alot of records to
move.

 

[Michael Nemtsev]

Hello UJ,

Where is records keept? If in DB then why not to use stored procedures for
this?

U> I need to move specific records from one server to another as part of
U> a customer upgrade process. What's the easiest way to do this? I
U> could use a DataTable to get the data and then write out a text
U> insert statement but that seems pretty cumbersome. Is there some way
U> I could read in the datatable, change where it points to and then
U> update it?
U>
U> TIA - Jeff.
U>
---
WBR,
Michael Nemtsev :: blog: http://spaces.live.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

 

[UJ]

It's all on SQL server. I may end up just doing a stored proc that will do
everything. I guess my thought was that the error control on a stored proc
isn't all the great.

Thanks.