Re: SQL Server - synchronizing database changes across servers

On Mar 28, 3:33=A0am, Erland Sommarskog 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/prodte=
chnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/p=
reviousversions/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

Re: SQL Server - synchronizing database changes across servers

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/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx