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 |
|
chedderslam
Posting Yak Master
223 Posts |
 Posted - 2010-06-26 : 13:24:28
|
| Not sure if this is the proper forum, so sorry if it is not.Client mentioned SQL/MED and I would like to learn more about it. Found the wikipedia page but not much else. Any good resources out there? Google fails me. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
robe
Starting Member
1 Post |
Posted - 2010-07-23 : 11:22:11
|
| SQL Server supports something called Linked Servers which is very similar in concept to SQL\MED and serves the same purpose.In many cases its better since there are lots of drivers (OLEDB/ODBC, .NET) available for all kinds of data sources.Here is an example of how we use it to link to our PostgreSQL servers.http://www.postgresonline.com/journal/archives/46-Setting-up-PostgreSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html As far as PostgreSQL SQL/MED goes its targeting ANSI compliance but still a work in progress. Will probably be much more beefed up in PostgreSQL 9.1. Its really the drivers that makes the most difference not just compliance. |
 |
|
|
|
|
|
sql/med