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!

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

On Mar 28, 3:33am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> 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

javelin (google.1.jvmail@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, 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