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 using the VPN

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-05 : 08:37:11
Inoon writes " Dear Sir,

I need to do a replication. One Server is hosted at UK and another at AUS.

I need to replcate the AUS sever in the night by runing the shedule.

How can I do this ?
Or Where can I find some good examples ?

thank you
Jiffry"

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2002-09-05 : 08:46:43
How big is the database ?

If it is not to big you could run transactional replication each night, which is very easy to set up. See BOL or search this site.

Do the UK people need to update the data or just read it ?? If they need to update then you will have to consider alternatives ?

What version of SQL Server are you using ?


===========
Paul
Go to Top of Page
   

- Advertisement -