Connecting web sql server with my local Sql Server

11 Apr 2006 10:06 AM

Alok yadav

Sir,
   i have two phase of my application one is website which saves data in sql
database and other application is on the intra net i have to update the
intranet database with the database which is on web server.
    i have to do it by coding can u help me to update my local database with
the remote sql server.
    can we also register the remote sql server which is on web on our local
sql server

11 Apr 2006 4:22 PM

Jeff Dillon

Look into "Linked Servers"

Jeff
Show quote

"Alok yadav" <Alokya***@discussions.microsoft.com> wrote in message
news:BEC0CA19-DC29-49E0-A5E5-AF6105E8D746@microsoft.com...
> Sir,
>   i have two phase of my application one is website which saves data in
> sql
> database and other application is on the intra net i have to update the
> intranet database with the database which is on web server.
>    i have to do it by coding can u help me to update my local database
> with
> the remote sql server.
>    can we also register the remote sql server which is on web on our local
> sql server

12 Apr 2006 8:30 AM

Alok yadav

I have searched msdn but i dont get any help. if u have ne code plz help me

12 Apr 2006 3:50 PM

Jeff Dillon

Not MSDN. SQL Books Online. There is no code..you use SQL Admin to set up
Linked Servers.

Are these databases on the same server? If so, then you can just use 4 part
naming. server.db.user.table

Jeff

Show quote

"Alok yadav" <Alokya***@discussions.microsoft.com> wrote in message
news:B2605799-40C9-4332-86C6-0D0596F40EEA@microsoft.com...
>I have searched msdn but i dont get any help. if u have ne code plz help me

14 Apr 2006 10:30 AM

Alok yadav

one database be on webserver and other is on my local machine i have to
shyncronize them so if any dataupadted on webserver then my local machine
database also get updated

17 Apr 2006 4:35 PM

Jeff Dillon

Yep, use linked servers. You can run queries from one to the other.

Jeff
Show quote

"Alok yadav" <Alokya***@discussions.microsoft.com> wrote in message
news:516A5A5A-BB45-4F0B-8866-365BC350ABB0@microsoft.com...
> one database be on webserver and other is on my local machine i have to
> shyncronize them so if any dataupadted on webserver then my local machine
> database also get updated