SQL transfers between databases

[T Arrowood]

Is is possible to insert into a databse table values from a table having the same format that resides in another database/table ??

I have tried :

xx = database a (source), yy=database b (Target)

select * into yy.dbo.target_Table from xx.dbo.source_table where.......

this does not seem to work.. any suggestions ???

[Craig]

You would have to define each server to the other and use RPC. See books online for setup.


------------
T Arrowood at 6/21/99 11:31:07 AM


Is is possible to insert into a databse table values from a table having the same format that resides in another database/table ??

I have tried :

xx = database a (source), yy=database b (Target)

select * into yy.dbo.target_Table from xx.dbo.source_table where.......

this does not seem to work.. any suggestions ???

[SATYA]

if databases are in same server...

insert into yy.dbo.target_Table from xx.dbo.source_table where.......




------------
Craig at 6/21/99 1:02:30 PM

You would have to define each server to the other and use RPC. See books online for setup.


------------
T Arrowood at 6/21/99 11:31:07 AM


Is is possible to insert into a databse table values from a table having the same format that resides in another database/table ??

I have tried :

xx = database a (source), yy=database b (Target)

select * into yy.dbo.target_Table from xx.dbo.source_table where.......

this does not seem to work.. any suggestions ???

[Ed Alexander]

If your databases are on the same server, you should be able to use:

insert into db1..table1(field1, field2,.....)
select field1, field2,...... from db2..table2


If the databases are on separate servers, see help on RPC as stated in a previous reply.


------------
T Arrowood at 6/21/99 11:31:07 AM


Is is possible to insert into a databse table values from a table having the same format that resides in another database/table ??

I have tried :

xx = database a (source), yy=database b (Target)

select * into yy.dbo.target_Table from xx.dbo.source_table where.......

this does not seem to work.. any suggestions ???