PHWinfo - Afficher un message - SQL Server - synchronizing database changes across servers

27/03/2008, 00h49

javelin (google.1.jvmail@spamgourmet.com) writes:
> Can someone recommend a utility (preferably open-source) to
> synchronize changes across servers? I need to bring only data over in
> some cases, and only objects in other cases. Any ideas?

Have you looked at replicatoin that comes with SQL Servers?

The tools from Red Gate are popular, although they are not open source.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

27/03/2008, 00h49	#2
Erland Sommarskog Messages: n/a Hébergeur:	Re: SQL Server - synchronizing database changes across servers javelin (google.1.jvmail@spamgourmet.com) writes: > Can someone recommend a utility (preferably open-source) to > synchronize changes across servers? I need to bring only data over in > some cases, and only objects in other cases. Any ideas? Have you looked at replicatoin that comes with SQL Servers? The tools from Red Gate are popular, although they are not open source. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx