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
 Replication (2008)
 Synchronization of Two server

Author  Topic 

Gautham
Starting Member

2 Posts

Posted - 2009-09-15 : 01:13:49
Hello,

I have two Sql Server(2005) of same type

The one is the working server in which I may change the data and design too. When I synchronise that with the the second database, I want update the second database.


I want to do with the help of c# code and with scripting Language. Can any one help me please

Thankyou your's
Gautham.


gauthamshetty86

krishnarajeesh
Yak Posting Veteran

67 Posts

Posted - 2009-11-06 : 12:29:25
If you are looking for replication setup for this, am hoping you are making change including schema to the source & the same has to be reflected on the destination, you could use transactional replication, with option Replicate schema change to true.

Thanks,
Krishna
www.SQLServer.in
Go to Top of Page
   

- Advertisement -