Copy Data....

Greetings,
Here's my problem. I have 2 databases, both on different instance installs,
with two identical tables. I want to copy the "Region" column data from one
table to the "Region" column of the other table. I thought this would be a
simple copy and paste situation, but apparently not. Any ideas?
Thanks
Ken S.You could either us DTS (export/Import) with a query that
select's only the column your interested in.
Or you could BCP with a select statment like so...
bcp "select column_name FROM db.dbo.table(nolock)"
queryout \\server\d$\ouput.txt -N -T -SServername -
eerror.err -b10000
>--Original Message--
>Greetings,
>Here's my problem. I have 2 databases, both on different
instance installs,
>with two identical tables. I want to copy the "Region"
column data from one
>table to the "Region" column of the other table. I
thought this would be a
>simple copy and paste situation, but apparently not. Any
ideas?
>Thanks
>Ken S.
>
>.
>|||OK great...let me try the DTS option first...
<anonymous@.discussions.microsoft.com> wrote in message
news:020401c3c4fe$62585800$a001280a@.phx.gbl...
> You could either us DTS (export/Import) with a query that
> select's only the column your interested in.
> Or you could BCP with a select statment like so...
> bcp "select column_name FROM db.dbo.table(nolock)"
> queryout \\server\d$\ouput.txt -N -T -SServername -
> eerror.err -b10000
> >--Original Message--
> >Greetings,
> >
> >Here's my problem. I have 2 databases, both on different
> instance installs,
> >with two identical tables. I want to copy the "Region"
> column data from one
> >table to the "Region" column of the other table. I
> thought this would be a
> >simple copy and paste situation, but apparently not. Any
> ideas?
> >
> >Thanks
> >
> >Ken S.
> >
> >
> >.
> >