LINKED SERVER

#31

Noor,

No, it is not the only option. You can use a linked server and a
distributed transaction to get data to the other server.

However, you will have to decide how to handle the case when you cannot for
some reason reach the remote server. Replication has that handling built
in, but you could create your own solution if your needs are simple enough.

RLF

"Noor" <naissani (AT) hotmail (DOT) com> wrote

Quote:

Thanks for your information, I only need to update couple of columns data
from USA to Canada or may be from Canada to USA not all the tables.

Replication is only the solution?

Thanks

"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote in message
news:uTA4qLYmIHA.464 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Noor,

Canada and USA servers are linked in what way, what is your line speed
between the servers, et cetera.

Unless the communication is pretty fast, I doubt that you want to use a
distributed transaction to keep the two servers in sychronization. And,
even if it is fast it can go down. Do you want one server to be locked
up waiting for the other to respond? I would not recommend that kind of
dependency between remote servers.

I would suggest that you read about replication to see if that serves
your needs. If you want updates to flow both directions, then read about
merge replication. Here is a link to some replication tuturials:
http://msdn2.microsoft.com/en-us/library/aa337389.aspx

If you pursue replication as a strategy, you can post additional
questions at: microsoft.public.sqlserver.replication

RLF

"Noor" <naissani (AT) hotmail (DOT) com> wrote in message
news:uVb8U1RmIHA.5692 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
Dear Professional,

I would highly appreciate if you can guide me for my one problem, I have
two servers and I want to create link server. One is at Canada and other
one is at USA. Now the problem is that both are not on domain and I am
wondering about performance. I might to update the information if
happend on Canada box to USA box. Now the question is SP_ADDLINKEDSERVER
is a good option to do this? In which box I have to create Linked Server
Canada Box or USA Box? this should be real time update, how about
performance? any thing I have to take care before creating linked server
on the production box?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

LINKED SERVER

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: LINKED SERVER - 04-09-2008 , 08:43 AM