|
|
|
date: Thu, 7 Aug 2008 06:55:01 -0700,
group: microsoft.public.sqlserver.server
back
Re: Copy tables from seperate servers
My mistake
You can use SSIS ( Integration Service), or if you have all the destination
server connected to the source as linked server, then you can use INSERT
INTO/SELECT INTO
for e.g
source server :B
Destination Server :A
trnasfering TABLE from B to A
--if the table exists in the destination server
insert into [A].[DATABASE].DBO.[TABLE]( COLUMN1,COLUMN2)
SELECT COLUMN1,COLUMN2 FROM [B].[DATABASE].DBO.[TABLE]
OR
SELECT COLUMN1,COLUMN2 FROM into [A].[DATABASE].DBO.[TABLE] from
[B].[DATABASE].DBO.[TABLE]
--
vinu
http://oneplace4sql.blogspot.com/
"vinu" wrote in message
news:e%23frMbJ%23IHA.1512@TK2MSFTNGP06.phx.gbl...
> Hi
>
> You can use SSIS ( Integration Service), or if you have all the
> destination server connected to the source as linked server, then you can
> use INSERT INTO/SELECT INTO
> for e.g
> source server :A
> Destination Server :b
> trnasfering TABLE from A to B
>
>
> --if the table exists in the destination server
> insert into [A].[DATABASE].DBO.[TABLE]( COLUMN1,COLUMN2)
> SELECT COLUMN1,COLUMN2 FROM [B].[DATABASE].DBO.[TABLE]
>
>
> OR
>
> SELECT COLUMN1,COLUMN2 FROM into [A].[DATABASE].DBO.[TABLE] from
> [B].[DATABASE].DBO.[TABLE]
>
> vinu
> http://oneplace4sql.blogspot.com/
>
>
>
> "Dan @BCBS" wrote in message
> news:A32A0898-1A96-4DE8-BAEB-83C1EAD31850@microsoft.com...
>> Using SQL Server Management Studio.
>> I have connections to many different SQL servers.
>> I need to move some tables from one server to another to consolidate.
>> This should be a basic question but I'm struggling with it. How do I copy
>> to
>> tables over?
>>
>> Thanks
>>
>>
>>
>
>
date: Thu, 7 Aug 2008 15:14:32 +0100
author: vinu
Re: Copy tables from seperate servers
Help me understand: Both servers are connected.
From the table I want to copy, do I right click for the "Script Table As"
then "Insert To". Is that what youare refering to?
When I do that my choices are: New Query Editor Window, File, Clipboard.
Thanks
"vinu" wrote:
> My mistake
>
>
> You can use SSIS ( Integration Service), or if you have all the destination
> server connected to the source as linked server, then you can use INSERT
> INTO/SELECT INTO
> for e.g
> source server :B
> Destination Server :A
> trnasfering TABLE from B to A
>
>
> --if the table exists in the destination server
> insert into [A].[DATABASE].DBO.[TABLE]( COLUMN1,COLUMN2)
> SELECT COLUMN1,COLUMN2 FROM [B].[DATABASE].DBO.[TABLE]
>
>
> OR
>
> SELECT COLUMN1,COLUMN2 FROM into [A].[DATABASE].DBO.[TABLE] from
> [B].[DATABASE].DBO.[TABLE]
>
>
>
> --
>
> vinu
> http://oneplace4sql.blogspot.com/
>
>
>
> "vinu" wrote in message
> news:e%23frMbJ%23IHA.1512@TK2MSFTNGP06.phx.gbl...
> > Hi
> >
> > You can use SSIS ( Integration Service), or if you have all the
> > destination server connected to the source as linked server, then you can
> > use INSERT INTO/SELECT INTO
> > for e.g
> > source server :A
> > Destination Server :b
> > trnasfering TABLE from A to B
> >
> >
> > --if the table exists in the destination server
> > insert into [A].[DATABASE].DBO.[TABLE]( COLUMN1,COLUMN2)
> > SELECT COLUMN1,COLUMN2 FROM [B].[DATABASE].DBO.[TABLE]
> >
> >
> > OR
> >
> > SELECT COLUMN1,COLUMN2 FROM into [A].[DATABASE].DBO.[TABLE] from
> > [B].[DATABASE].DBO.[TABLE]
> >
> > vinu
> > http://oneplace4sql.blogspot.com/
> >
> >
> >
> > "Dan @BCBS" wrote in message
> > news:A32A0898-1A96-4DE8-BAEB-83C1EAD31850@microsoft.com...
> >> Using SQL Server Management Studio.
> >> I have connections to many different SQL servers.
> >> I need to move some tables from one server to another to consolidate.
> >> This should be a basic question but I'm struggling with it. How do I copy
> >> to
> >> tables over?
> >>
> >> Thanks
> >>
> >>
> >>
> >
> >
>
>
>
date: Thu, 7 Aug 2008 07:43:00 -0700
author: Dan @BCBS
Re: Copy tables from seperate servers
Do this
Open the management studio connect to the source server, then tell me what
you see under Server Objects->linked Server. if nothing is listed under
linked server tab, means; servers are not connected. you need to configure
the linked server
vinu
http://oneplace4sql.blogspot.com/
"Dan @BCBS" wrote in message
news:45681778-4D5B-450C-8E95-6AA2146AE0A0@microsoft.com...
> Help me understand: Both servers are connected.
> From the table I want to copy, do I right click for the "Script Table As"
> then "Insert To". Is that what youare refering to?
> When I do that my choices are: New Query Editor Window, File, Clipboard.
>
> Thanks
>
>
>
>
>
>
> "vinu" wrote:
>
>> My mistake
>>
>>
>> You can use SSIS ( Integration Service), or if you have all the
>> destination
>> server connected to the source as linked server, then you can use INSERT
>> INTO/SELECT INTO
>> for e.g
>> source server :B
>> Destination Server :A
>> trnasfering TABLE from B to A
>>
>>
>> --if the table exists in the destination server
>> insert into [A].[DATABASE].DBO.[TABLE]( COLUMN1,COLUMN2)
>> SELECT COLUMN1,COLUMN2 FROM [B].[DATABASE].DBO.[TABLE]
>>
>>
>> OR
>>
>> SELECT COLUMN1,COLUMN2 FROM into [A].[DATABASE].DBO.[TABLE] from
>> [B].[DATABASE].DBO.[TABLE]
>>
>>
>>
>> --
>>
>> vinu
>> http://oneplace4sql.blogspot.com/
>>
>>
>>
>> "vinu" wrote in message
>> news:e%23frMbJ%23IHA.1512@TK2MSFTNGP06.phx.gbl...
>> > Hi
>> >
>> > You can use SSIS ( Integration Service), or if you have all the
>> > destination server connected to the source as linked server, then you
>> > can
>> > use INSERT INTO/SELECT INTO
>> > for e.g
>> > source server :A
>> > Destination Server :b
>> > trnasfering TABLE from A to B
>> >
>> >
>> > --if the table exists in the destination server
>> > insert into [A].[DATABASE].DBO.[TABLE]( COLUMN1,COLUMN2)
>> > SELECT COLUMN1,COLUMN2 FROM [B].[DATABASE].DBO.[TABLE]
>> >
>> >
>> > OR
>> >
>> > SELECT COLUMN1,COLUMN2 FROM into [A].[DATABASE].DBO.[TABLE] from
>> > [B].[DATABASE].DBO.[TABLE]
>> >
>> > vinu
>> > http://oneplace4sql.blogspot.com/
>> >
>> >
>> >
>> > "Dan @BCBS" wrote in message
>> > news:A32A0898-1A96-4DE8-BAEB-83C1EAD31850@microsoft.com...
>> >> Using SQL Server Management Studio.
>> >> I have connections to many different SQL servers.
>> >> I need to move some tables from one server to another to consolidate.
>> >> This should be a basic question but I'm struggling with it. How do I
>> >> copy
>> >> to
>> >> tables over?
>> >>
>> >> Thanks
>> >>
>> >>
>> >>
>> >
>> >
>>
>>
>>
date: Thu, 7 Aug 2008 16:27:39 +0100
author: vinu
|
|
