Friday, February 17, 2012

Connecting two tables

Hi All
I have 2 tables of same structure and data, one in the local database and another in the remote database. The local database is used for intranet site and remote database for internet site. If some one adds or modify a record in local database, thats should automatically reflect(add or modify) in external database. Is it possible to do this '. If it is, can anybody please give me a hint
Thanks in Advance
JPLook up Replication in BOL (Books On-Line). This is a great way to move data
from a central server to a reporting server elsewhere.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
CareerBuilder.com
"JP" <anonymous@.discussions.microsoft.com> wrote in message
news:EA0DD15F-790C-41B6-A47D-2D0BE64EA229@.microsoft.com...
> Hi All,
> I have 2 tables of same structure and data, one in the local database and
another in the remote database. The local database is used for intranet site
and remote database for internet site. If some one adds or modify a record
in local database, thats should automatically reflect(add or modify) in
external database. Is it possible to do this '. If it is, can anybody
please give me a hint.
> Thanks in Advance.
> JP|||Hi,
As Geoff points out, Replication is a great way to synchronize two different
databases. There are lots of documentation available, although it might seem
difficult in the beginning, it is quite simple if you get the fundamentals
right. Good luck.
Aditya.
"JP" <anonymous@.discussions.microsoft.com> wrote in message
news:EA0DD15F-790C-41B6-A47D-2D0BE64EA229@.microsoft.com...
> Hi All,
> I have 2 tables of same structure and data, one in the local database and
another in the remote database. The local database is used for intranet site
and remote database for internet site. If some one adds or modify a record
in local database, thats should automatically reflect(add or modify) in
external database. Is it possible to do this '. If it is, can anybody
please give me a hint.
> Thanks in Advance.
> JP

No comments:

Post a Comment