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 2008 Forums
 SQL Server Administration (2008)
 replication

Author  Topic 

pramod21
Yak Posting Veteran

64 Posts

Posted - 2011-10-07 : 02:12:21
Hi,
my development server is in india and my production server is in US.
I want to implement replication on these two server.can u plz tell me the proper setting and way for doing this...

Thanks..

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-07 : 02:15:05
what replication set up you want? is it transaction or merge?
anyways see
http://www.databasejournal.com/features/mssql/article.php/1438201/Setting-Up-Transactional-Replication-A-Step-by-step-Guide.htm

http://www.databasejournal.com/features/mssql/article.php/1438231/Setting-Up-Merge-Replication-A-Step-by-step-Guide.htm

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2011-10-07 : 02:51:32
quote:
Originally posted by pramod21

Hi,
my development server is in india and my production server is in US.
I want to implement replication on these two server.can u plz tell me the proper setting and way for doing this...

Thanks..



What kind of network do you have ?

PBUH

Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2011-10-13 : 16:39:41
Why Would you want to replicate Production Server to Development Server? Not a good approach.It will affect performance.
Go to Top of Page
   

- Advertisement -