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 |
|
sdiwi
Starting Member
27 Posts |
 Posted - 2005-07-25 : 11:33:25
|
Hi guys.Imagine following scenario:I have 2 SQL-Servers - one stores the data for the intranet , the other stores the public stuff for the web.Now my Web-SQL-Server needs data from the Intranet-SQL-Server.The only thing that comes to my mind right now, is "publication"...But this is nasty - too slow and simply too much overhead for my case.Can I somehow use stored procedures or udfs or sth. to exchange data between 2 sql servers? Any examples or sth?I would be really grateful, because I might be in serious trouble if I can't find a way ...  - but what doesn't kill you just makes you tough  .Thank you,peace,Sdiwi. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-07-25 : 12:04:39
|
"sth" New word to me. What does it mean? Is that some kind of chatroom-speak? Please translate to English.quote:
Originally posted by sdiwi...Can I somehow use stored procedures or udfs or sth. to exchange data between 2 sql servers? Any examples or sth?...
CODO ERGO SUM |
 |
|
|
sdiwi
Starting Member
27 Posts |
Posted - 2005-07-25 : 12:34:55
|
| @michaeli hope you're not making fun of me somehow. you're from the us, so if you have been in school, you should have learned the abbreveation for something...greetings,peace,sdiwi. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-07-25 : 13:58:27
|
I think you are the one who is kidding me. "sth" is not an abbreveation of "something" that I have ever heard of, and it isn't listed as that in any of the dictionaries I looked in.quote:
Originally posted by sdiwi
@michaeli hope you're not making fun of me somehow. you're from the us, so if you have been in school, you should have learned the abbreveation for something...greetings,peace,sdiwi.
CODO ERGO SUM |
|
|
|
klegrand
Starting Member
29 Posts |
Posted - 2005-07-26 : 02:42:23
|
| You have to use the linked servers to exchange data. You find this topic under 'Security'Hope this will help you.Kurt |
|
|
|
|
|
|
|
|
Sharing / Exchanging Data Between Two SQL Servers