By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,396 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

SQL Server - synchronizing database changes across servers

P: n/a
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?

Thx!
Mar 26 '08 #1
Share this Question
Share on Google+
5 Replies


P: n/a
javelin (go*************@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, es****@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
Mar 26 '08 #2

P: n/a
On Mar 26, 5:49 pm, Erland Sommarskog <esq...@sommarskog.sewrote:
javelin (google.1.jvm...@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, esq...@sommarskog.se

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
I was under the impression that replication would produce a complete
copy. I want to leave objects alone so that I can propagate only data
changes at times, and at other times, only stored procedures or other
objects. Redgate looks good, except for the price, which is way out
there.
Mar 27 '08 #3

P: n/a
javelin (go*************@spamgourmet.com) writes:
I was under the impression that replication would produce a complete
copy. I want to leave objects alone so that I can propagate only data
changes at times, and at other times, only stored procedures or other
objects. Redgate looks good, except for the price, which is way out
there.
I believe that you can setup replication so that it only copies data, not
table description and that. You can even set it up, so that it does
not perform any initial replication of existing. Good when you started
with restoring a backup.

Replication is less useful for replicating object deinfitions only, though.

Too bad that the Red Gate tools are over your budget, but I hope that you
have plenty of time on your hands. That is, the labour cost can easily
exceed the Red Gate price tag, which I don't recall as extortionate.

--
Erland Sommarskog, SQL Server MVP, es****@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
Mar 28 '08 #4

P: n/a
On Mar 28, 3:33*am, Erland Sommarskog <esq...@sommarskog.sewrote:
javelin (google.1.jvm...@spamgourmet.com) writes:
I was under the impression that replication would produce a complete
copy. I want to leave objects alone so that I can propagate only data
changes at times, and at other times, only stored procedures or other
objects. Redgate looks good, except for the price, which is way out
there.

I believe that you can setup replication so that it only copies data, not
table description and that. You can even set it up, so that it does
not perform any initial replication of existing. Good when you started
with restoring a backup.

Replication is less useful for replicating object deinfitions only, though..

Too bad that the Red Gate tools are over your budget, but I hope that you
have plenty of time on your hands. That is, the labour cost can easily
exceed the Red Gate price tag, which I don't recall as extortionate.

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

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Well, the cost of Redgate products is pretty fair, for a single user
license. For several users, it starts climbing the tree of expense. I
thought Total Access used to create just such a product. I think it
was pretty decent at the time, but I see that they are no longer
producing anything like that.

I'm still open to suggestions on 3rd party products or or open source
coding from anyone.

Thanks.

J
Apr 1 '08 #5

P: n/a
javelin (go*************@spamgourmet.com) writes:
Well, the cost of Redgate products is pretty fair, for a single user
license. For several users, it starts climbing the tree of expense. I
thought Total Access used to create just such a product. I think it
was pretty decent at the time, but I see that they are no longer
producing anything like that.

I'm still open to suggestions on 3rd party products or or open source
coding from anyone.
You have been fairly terse on what you really are up to, and the answers
you get will be accordingly. How was I too know that you would need a
multi-user license for your replication business.

It's possible that you can build something with SQL Server Integration
Services, although I have never used it myself.

You could also gives us more details about your application, and maybe
we could think of something.
--
Erland Sommarskog, SQL Server MVP, es****@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
Apr 1 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.