How to import/export tables once a linked server is made??

[Smithesh Kollara]

Hi Everyone,

I have made a Linked Server in SQL Server with tables in from a remote
Oracle Database.

How will i import it to my Local SQL Database from this particular Linked
Server??

Regards,

Smithesh Kollara

[Bas Kersten]

by using four-part names:

The system stored procedures sp_addlinkedsrv and sp_addlinkedserverlogin are
used to give a server name to an OLE DB data source. Objects in these linked
servers can be referenced in Transact-SQL statements using four-part names.
For example, if a linked server name of DeptSQLSrvr is defined against
another copy of SQL Server 7.0, the following statement references a table
on that server:

SELECT * FROM DeptSQLSrvr.Northwind.dbo.Employees

hth
Bas

"Smithesh Kollara" <kollara...@hotmail.com> wrote in message
news:#kpFqxJsBHA.1816@tkmsftngp07...

[Bill]

Hi Smithesh

You're further along than I am.

How did you create the SQL linkage? What version of SQL server are you
running? Is it on your dev machine or out on your network?

BTW, have you looked at the sample apps in your SQL CE directory? There
seems to be some stuff that shows how to move the data around.

Thanks

-Bill

Ness Technologies

"Smithesh Kollara" <kollara...@hotmail.com> wrote in message
news:#kpFqxJsBHA.1816@tkmsftngp07...