replication

Outlook Replication API.

Hi All, The Outlook ReplicationAPI can used to sync with server other than MS Exchange Server? Because i try to use it to sync with my proprietary server. Thanks. ...

SQL Server Change Tracking vs Replication vs Differential Backup

Ok we have critical transactional database and its in full recovery mode in SQL Server 2008. We have have two different servers in two different data centers on two different timezones. And I am trying to setup best way to make database as upto date as possible using various options. Database is currently only 1.5GB, expected to grow 1GB...

Stored Procedure Replication or copying (SQL Server)

Is it posible to replicate or copy the stored procedure easy from one SQL Server to an other? ...

SQL Replication sopping - removing tables from Full Text Index catalog

We have a sql 2000 db that has some replicated tables (from another server) We're using full text indexing Sometimes, network connectivity stops replication, requiring us to restart it, which isn't a problem- however, this seems to remove the replicated tables from the full text catalogs, which causes problems Any ideas how i can fix t...

Find most recent SQL Server database activity

Data from another system is replicated into a SQL Server 2005 database in real-time (during the day, it's hundreds of transactions/second) using Goldengate. I'd like to be able to tell if there's been a transaction recently, which will tell me if replication is currently happening. Even in the off-hours, I can expect a transaction every ...

What's the difference between peer-to-peer and merge replication with SQL Server?

What's the difference between peer-to-peer replication and merge replication using SQL Server? ...

Replication from MySQL to MS SQL

Hello, I'm facing a new challenge here. I can't seem to find precedence for replication from MySQL, running on a Linux box to MS SQL Server. Has anybody done this before? Most importantly all changes made to the MySQL database should be replicated on the MS database realtime or close. MS database are not likely to be updated in any ot...

MySQL query based replication

Hi, I wish to road-test a MySQL Cluster instance by passing it all query which are executed on InnoDB MySQL instance. I'm not too worried about data integrity on the Cluster at present, this study is focused on the stability and speed of the Cluster. I do not wish to use statement-based binary log replication as queries which are purely...

autoincrement primary key and replication

Recently I was told to add auto_increment primary key to all our tables because our database is going to be replicated (master-master solution). All our tables had some kind of primary key, but not all of them were autoincremented. I looked through mysql documentation about replication and I didn't find any indication that this (auto_in...

Keeping distributed databases synchronized in a unstable network

I'm facing the following challenge: I have a bunch of databases in different geographical locations where the network may fail a lot (I'm using cellular network). I need to keep all the databases synchronized but there is no need to be in real time. I'm using Java but I have the freedom to choose any free database. Any suggestions on h...

Database replication SQL Server 2008 to Mysql

I have to create real time replication from SQL Server 2008 to Mysql. It should be one directional data synchronizing. Has anybody done this before? Thanks. ...

Offline replication using files

Is it possible to organize asynchronous data exchange with separate files (transportable tablespaces maybe) using Oracle Streams? I.e, is it possible to organize offline replication using files? ...

Ruby On Rails Master-Slave Postrgres Databases

I am currently setting up a master-slave app using Ruby on Rails that needs to have a Master-Slave backend. I'm currently looking at using Slony for the replication component, and Masochism for handling the read/write connections to the different DBs. This is my first time setting up master-slave DBs with Ruby on Rails, and these are t...

How do I keep a table synchronized with a query in SQL Server - ETL?

I wan't sure how to word this question so I'll try and explain. I have a third-party database on SQL Server 2005. I have another SQL Server 2008, which I want to "publish" some of the data in the third-party database too. This database I shall then use as the back-end for a portal and reporting services - it shall be the data warehouse. ...

MySQL: Writing to slave node

Lets say I have a datbase of Cars. I have Makes and Models (FK to Makes). I plan on having users track their cars. each Car has a FK to Model. Now, I have a lot of users, and I want to split up my database to distribute load. The Makes and Models tables don't change so much, but they need to be shared across shards. My thought is to use ...

Why do I have duplicate rows for the same subscriber in my MSmerge_identity_range table?

Hello, I have a database with merge replication set up on a SQL 2005 server with 1 subscriber. I am having some identity range issues an I started to look at the MSmerge_identity_range table. I have one subscriber but 2 rows for each. For Example(I shortend the guids but for arguments sake they are the same for each row): subid ar...

Bidirectional replication update record problem

Hi, I would like to present you my problem related to SQL Server 2005 bidirectional replication. What do I need? My teamleader wants to solve one of our problems using bidirectional replication between two databases, each used by different application. One application creates records in table A, changes should replicate to second datab...

Do you need triggers on a mysql database slave?

Say you are running two mysql servers: one a master, the other the slave. The master has triggers set that update columns with the COUNT of the number of rows in other tables. For instance, you have a news table and a comments table. News contains an INT column called "total_comments" which is incremented via trigger every time a new ...

integer primary key for replication

I am weighing my options for integer primary keys that can be used in multi master replication. (I'm pretty much sold on using integer keys instead of GUIDs) The best I can come up with is having the most significant data first and having the server number last: eg. invoice 1 on server 1 = 101 invoice 1 on server 2 = 102 where the non s...

Is it possible to do N-master => 1-slave replication with MySQL ?

Hello, I want to make a dedicated SLAVE machine for data replication of three database on three different servers. In other words, I want to do Multiple Master => SIngle Slave replication. Is there any way to do this, as simple as it can be ? Thanks ! ...