Connecting web sql server with my local Sql Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top