How to create Database link in MsSqlServer to Oracle8i

Hi All,
Can somebody please help me, how to create database link to Oracle from MsSqlServer200.

Ex:
If I want to view data in both databases at a time then query would be like the following:

dblink name : SqltoOraclelink
table Name : EMP (this could be available in both the databases)

query in MsSqlServer200 EnterpriseManger:
select empname, empno from EMP msemp, emp@.SqltoOracle oraemp where msemp.empname = oraemp.empname

Then this query results the rows from both the databases where empname is same in both the tables

My question is: How can I create this Database link "SqltoOraclelink" as I can do the same thing in Oracle.

As this is in urgency, it would be greate if somebody help us asap.

Thanks in Anticipation,
Regards,
RKThis article should help you out:
http://www.databasejournal.com/features/mssql/article.php/3290801

How to COPY table/database to another machine

Is it very involved to copy a database from one server to another in a seperate location? Or should I find a MSSQLSERVER forum to post this in?

The short answer to your move question is, not necessarily.
In Enterprise Manager, right-click your database, choose "All Tasks" and then either "Import Data..." or "Export Data..." (depending on what direction you're going).
This opens the "Data Transformation Services" wizard which can do just about everything you need for your move.
Keep in mind you'll need the appropriate SQL Server port accessiable to where your data is going, and recreating Account permissions in the new location may need some extra attention.
Hope that gets you started well enough.|||Create a linked server and then do a normal select against it
insert into newServer.database.dbo.tableName
select * from oldServerTableName

Nick|||I want to copy it to a disk or usb stick, and bring it to a non networked PC( will be networked later). I looked into the export feature in Enterprise mgr. Not sure what to export it to. Am I in the ballpark?|||

How large is your DB? If its not to large, create backups and port those over to the other machine and do a restore. If its large, you might have trouble moving the data around depending on the type of device you are going to use (CDs, DVDs, etc)
Nick

|||It looks like it will not allow me to back it up to a file but it's looking for a device like some tape backup which I do not have). How picky is this thing?
|||Scratch that last post, I got it to work on another drive but it was picky about my initial choice. Does the resultant file have to have a certain extension to be restored?|||

No, the extension is not important. Just ensure you select the correct file when doing the Restore.

|||Thanks a bunch. THREAD CLOSED. ( I hope)