SQL Server - synchronizing database changes across servers

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • javelin

    SQL Server - synchronizing database changes across servers

    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

    #2
    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

    Books Online for SQL Server 2000 at

    Comment

    • javelin

      #3
      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.

      Comment

      • Erland Sommarskog

        #4
        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

        Books Online for SQL Server 2000 at

        Comment

        • javelin

          #5
          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

          Comment

          • Erland Sommarskog

            #6
            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

            Books Online for SQL Server 2000 at

            Comment

            Working...