replication

How can I find Replication Bytes Per second in SQL 2005?

Is there an easy way to get a bytes per second measurement for replication? I am trying to get a mesuarment for some networking people. Thanks ...

Basic CouchDB Local-to-Remote Replication

I am playing around with CouchDB Replication and I'm wondering how to copy a local database of name "myDatabase" to a remote database on www.mySite.com that requires ssh access, and rename it to "myRemoteDatabase". How do I do that? I am able to login to both the local and remote servers and run: curl -X GET http://localhost:5984/ .....

MySQL Database Replication for Multiple Tables

Previously, I have experience in doing the following database replication. (1) I have 2 tables within 1 database in Machine A (2) I update 2 tables in Machine A (3) Machine A will replicate 2 tables to Machine B. Machine B will also contain 2 tables within 1 database. Now, I would like to accomplish the following : (1) I have Table ...

Is DB4O Replication faster than SQL Server Merge Replication?

Does the replication system that comes with DB4O work well? Basically I would like to know if anyone has some good numbers on the record throughput of their replication system and if it handles concurrency errors gracefully or not. What is the relative performance difference between SQL Server's merge replication between two SQL server...

SQL Server 2005 Replication Not for Replication Attribute

I work for a company that has 32 locations, each location having its own SQL server. Replication is set up from each location to a central location, and then from the central location to a main office location. The main office location also has data that is entered, which replicates from the main office to the central location, and the...

SQL Server CE 3.5 Merge Replication

Hi, I am working on an application that will connect to SQL Server 2005 when users are in the office, or it will connect to SQL Server CE 3.5 when users are on a laptop and out of the office. I have been reading up on Merge Replication to keep the two in sync, but am having a hard time finding anthing from start to finish (all the docu...

SQL Server replication at the software level?

I have a need to make a remote connection through a DSL line (getting about 16k/s) to a SQL Express 2005 instance much faster. I think I can do it by having a SQL Express 2005 instance on the client's local machine and have it be a cached version of the data on the server. I'm planning to allow changes to the remote server only and the...

SQL Server: How to Determine all tables associated with replication, and which articles.

How would I iterate through the tables of a database, and determine which publication and article those tables are associated with? ...

Large scale Merge Replication strategy - what can go wrong?

Hi, I'm developing a piece of software that uses Merge Replication and SQL Compact on Windows Mobile 6. At the moment it is running on 5 devices reasonably well. The issues I've come up against are as follows: The schema has had to change a lot, and will continue to have to change as the application evolves. There have been various ...

Is it safe to set MySQL isolation to “Read Uncommitted” (dirty reads) for typical Web usage? Even with replication?

I'm working on a website with typical CRUD web usage pattern: similar to blogs or forums where users create/update contents and other users read the content. Seems like it's OK to set the database's isolation level to "Read Uncommitted" (dirty reads) in this case. My understanding of the general drawback of "Read Uncommitted" is that a ...

How to replicate two different database systems?

I'm not sure, if it fits exactly stackoverflow, however as i'm seeking for some code rather than a tool, i think it does. I'm looking for a way of how to replicate / synchronize different database systems -- in this case: mysql and mongodb. We are running both for different purpose. We started with a mysql database and added mongodb lat...

SQL Server VPN Replication

Hi, I have a requirement to use Sql replication from a sql server 2005 instance to a Sql 2000 instance over a vpn. The vpn is permanent between the 2 sites and there are only a few tables that need replicated. Can anyone give me any advantages/disadvantages of replication over vpn or any issues with replication between SQL 2005 and Sq...

MySql database synchronization

I have two different servers for mysql databases. First server is for master database and second server to act as slave. Now i need to synchronization all the changes being done on my master database to be applied to the slave database on real time basis. Please guide me with all the steps to implement real time mysql database synchroni...

SQL Server 2005, Replicating between timezones.

How does SQL Server handle the transfer of the datetime columns when replicating between timezones? ...

SQL Server Replication by column mapping

Is it possible to use SQL Server's replication service to replicate from table A on a given server to a different schema on table B? ie, Table A ---------- ID int Name varchar(20) Data text Table B ---------- ID int Name varchar(20) Description varchar(10) Replication would copy "Name" from table A to table B for a gi...

Using a duplicate SQL Server database for queries

I have a very large (100+ gigs) SQL Server 2005 database that receives a large number of inserts and updates, with less frequent selects. The selects require a lot of indexes to keep them functioning well, but it appears the number of indexes is effecting the efficiency of the inserts and updates. Question: Is there a method for keeping...

Replication to a redundant server with Rails?

I'm working on a Ruby on Rails/PostgreSQL web app that a mobile device communicates with. The mobile device has the ability to post to a primary server and geographically redundant secondary server at the same time. I would to replicate my user and profile data from the primary server to the secondary server instantaneously. Is ActiveRes...

Additional server between closed source client/server that does same requests but does not change data

I have the following setup: Closed-source Client A where I can set the IP of B Closed-source Server B, fixed IP Server C, written by me A communicates with B over HTTP. I've cloned the API and implemented it myself in C, as I am interested in the data, but I still require A to talk to B, which is why I can't just let the client conne...

SQL Server replication alerts delay

My problem is that for some reason there is a 15min delay between replication alerts (at the distribution agent), even when the underlying cause is the same transaction as what caused the previous alert. It's frustrating when I think that I've fixed the problem and then have to wait ages to see if it has any more to throw at me. Does an...

Entity Framework multi-language website with multi-database

As the question is a bit self explanatory, I want to achieve the goal of a multi-language website. I am using an Entity Data Model with MS SQL 2005. I came up with an idea of making a seperate database for each language with exactly the same model and relations. So I can use the Entities constructor that takes a connectionString and swit...