SQL Server - synchronizing database changes across servers

[javelin]

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!

[Erland Sommarskog]

Re: SQL Server - synchronizing database changes across servers

javelin (google.1.jvmai l@spamgourmet.c om) 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@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[javelin]

Re: SQL Server - synchronizing database changes across servers

On Mar 26, 5:49 pm, Erland Sommarskog <esq...@sommars kog.sewrote:

javelin (google.1.jvm.. .@spamgourmet.c om) 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...@sommarsk og.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.c om/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/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.

[Erland Sommarskog]

Re: SQL Server - synchronizing database changes across servers

javelin (google.1.jvmai l@spamgourmet.c om) 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, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[javelin]

Re: SQL Server - synchronizing database changes across servers

On Mar 28, 3:33 am, Erland Sommarskog <esq...@sommars kog.sewrote:

javelin (google.1.jvm.. .@spamgourmet.c om) 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...@sommarsk og.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.c om/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/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

[Erland Sommarskog]

Re: SQL Server - synchronizing database changes across servers

javelin (google.1.jvmai l@spamgourmet.c om) 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@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx