473,322 Members | 1,526 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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!
Mar 26 '08 #1
5 3238
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: cooldv | last post by:
i am running a website on Windows 2000 server with ASP 3 webpages and Access 2000 database. (with a hosting company) traffic is slow at this time but expect to grow. lately i have been reading...
3
by: EK | last post by:
I am trying to use asp to download a file located on a different server. I can use ADODB.Stream, LoadFromFile(\\Server\Something) and the Response.BinaryWrite successfully, but only if I create an...
0
by: tiacux | last post by:
Tech Associates is recruiting for: A SQL Server Database Systems Administrator for Jacksonville, Florida. Salary to $75,000. Description The Database Systems Administrator's role is to...
2
by: Christopher D. Wiederspan | last post by:
We are getting ready to move an ASP.NET application off of a single development machine and onto a "webfarm". Basically our webfarm is a bunch of identical servers with the load-balancing provided...
10
by: Br | last post by:
We have a product that is being used by a client to outsource salary packaging. They therefore run several instances of our database, one for each of their clients. There is now a requirement to...
3
by: RayPower | last post by:
I'm having a system using Access 2000 as both front-end (queries, forms, reports & temp tables for reports) & back-end (data) with back-end running on the server. The application runs on the...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
0
Coldfire
by: Coldfire | last post by:
Since i cannot show the differences in a two-column like table. I am first putting MS SQL Server 2005 and then MySQL 5.x. MS SQL Server 2005 Brief Overview - SQL Server is a full-fledged...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.