Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-03-23 : 07:23:47
Ali Awais writes "Hello!

I want to replicate a database from SQL Server through Internet.
I can use PCAnywhere for this purpose.

How can I connect to the that server?
How can I register my server on that SQL Server?
How can I use snapshot with updation, I want my server to be the subscriber and want that the other server to be the distributor and publisher. Data is both updated on my side as well as on the other side.

I am using personal edition of SQL Server and I dont know about the server installed in the other country.

Waiting anxiously for the reply.
S. M. Ali Awais"

jason
Posting Yak Master

164 Posts

Posted - 2005-03-23 : 15:39:42
First, I think you need to read through replication, connecting, registering, and snapshot in Books Online. Next you will need to work with the systems administrator in the 'other country' to determine methods for connecting to their SQL server over the Internet. PCAnywhere probably won't help you much. Finally, look through the FAQ's on this site to eliminate questions which have already been answered.

When you have a better understanding of the topic, you will be able to ask consise questions and get helpful answers from polished IT pro's.
Go to Top of Page
   

- Advertisement -