Hi Gowrisankar
Replication and DTS can be used to create copies of the database objects
and data on your local server. Replication can be setup to incrementally
pass changes from the remote server to your local server.
Is this the direction you wanted to go?
Nick Schueler
--------------------
| Content-Class: urn:content-classes:message
| From: "Gowrisankar" <mgowrisankar@rediff.com>
| Sender: "Gowrisankar" <mgowrisankar@rediff.com>
| Subject: Regarding connecting remote database
| Date: Sat, 20 Sep 2003 23:34:26 -0700
| Lines: 4
| Message-ID: <062e01c3800a$67044ff0$a301280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcOACmcE1SfKhrT+RM6murhtmsQ9Jg==
| Newsgroups: microsoft.public.sqlserver.connect
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.connect:37863
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.sqlserver.connect
|
| my sql server database is in remote place. how to create a
| instance of remote server database from my local machine.
| i want to access all of my tables which are available at
| remote sql server database.
|
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.