Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ethirajbalakrishnan
Starting Member
1 Post |
 Posted - 2003-01-03 : 15:43:55
|
| Hello sirs, I am junior to Oracle.Just i want to access my Sql Server database from my Oracle database.Is there any method available? Another doubt: Is it possible to have a common stored procedure which is going to access two databases[Oracle,Sqlserver]. if any alternate give me please.with advance thankssenthil. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-03 : 15:55:53
|
No idea about the first part. SQL Server allows you to link to other databases using the "linked servers" concept. You can find out more about it in Books Online. You'd have to post on an Oracle forum to find out if Oracle has a similar feature. If they do, they don't advertise it much.As far as cross-platform code, even if you can write something that works on both platforms, usually it just ends up performing poorly on BOTH of them. This is the greatest strength and greatest weakness of the Snitz forum code (the code used on these here SQL Team forums) It was written to work without modification on MS Access, SQL Server and MySQL (no Oracle support yet...what a shocker)  It performs well on MySQL and pretty good on MS Access, but has lots of room for improvement on SQL Server. You'd only cheat yourself of the most powerful features of a product by trying to write code that works on all of them. It's even fair to say that certain DATABASE designs work better on one platform than another, so it's unlikely you'll get the best performance from the most generic code. |
 |
|
|
|
|
|
Want to Access Sql Server db from my Oracle db