Connecting web sql server with my local Sql Server

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
 
J

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Server 2000 9
Cannot connect a remote sql server 9
Creating new sql database from a different server than sql 5
Problem connecting to SQL 2
Deploying sql server app 3
How import data from SQL Server? 2
Figuring sql server version via code 3
Error while connecting remote SQL server 17

Top