replication

Replicate Database

I want to execute proc of database 'A' from database 'B'. My situation is this that i have a database 'A' and a database 'B'. I want that when a proc is executed on database 'A' it will also execute on database 'B'. This is because whole structure is same on both database but some procs are different in database 'B'. I want to match resu...

SQL Server trigger on replication

I need to create a SQL Server database that will recieve updates by some replication mechanism from another database. I need to write insert, update and delete triggers that will execute when this replilcation occurs. I have experience with triggers but not with replication. Should I use Transactional or Merge replication, or does it m...

Publicly available SQL Server replication Publisher

I'm trying out SQL Server 2008 Express Edition and I'm interested in trying the replication features. Is there a publicly available database to which I could set up a replication subscription? ...

what type of database record id to use: long or guid ?

Hi In recent years I was using MSSQL databases, and all unique records in tables has the ID column type of bigint (long). It is autoincrementing and generally - works fine. Currently I am observing people prefer to use GUIDs for record's identity. Does it make sense to swap bigint to guid for unique record id? I think it doesn't make...

How do I replicate and validate data from remote systems into SQL Server

I have a task at hand of creating some kind of logic for a database. There is a IBM MQ Series setup in place today that replicates data from a couple of remote systems. At the moment it changes in the remote system and dumps the data into a staging table in a SQL Server 2005 database. I want to validate the data according to some simpl...

SQL Server Transactional Replication Over VPN

I have transactional replication running between two servers over a dedicated VPN connection. The databases are fairly large, so I initially use the backup and restore method to get the initial snapshot over to the subscriber machine and then let it apply the incremental transactions from there. Everything runs fine until the VPN line ...

SQL Server transactional replication, and adding new tables

I have a very large existing set of tables being replicated (transactional) between two servers over a dedicated VPN connection. I need to add a new table. Reloading all the tables is not an option. I thought that by simply adding the new articles to the publication it would replicate them across, but that didn't work. Of course, som...

Ehcache / Hibernate and RMI replication with large number of entities

Hi All, I'm currently investigating how to use the RMI distribution option in ehcache. I've configured properly ehcache.xml and replication seems to work fine. However I've 2 questions: -> It seems ehcache/ hibernate creates 1 cache per Entity. This is fine, however when replication is in place it create 1 thread / cache to replicate...

SQL Replication "Row Not Found" Error

I have transactional replication running between two databases. I fear they have fallen slightly out of sync, but I don't know which records are affected. If I knew, I could fix it manually on the subscriber side. SQL Server is giving me this message: The row was not found at the Subscriber when applying the replicated command. (S...

Copy SQL Server data from one server to another on a schedule

I have a pair of SQL Servers at different webhosts, and I'm looking for a way to periodically update the one server using the other. Here's what I'm looking for: As automated as possible - ideally, without any involvement on my part once it's set up. Pushes a number of databases, in their entirely (including any schema changes) from on...

Scaling a postgres server to multiple servers

Our postgres server is about hitting its capacity and we're looking into adding a second database server. Are there any scaling solutions that are particularly good for a postgres setup? ...

Advice Please: SQL Server Identity vs Unique Identifier keys when using Entity Framework

I'm in the process of designing a fairly complex system. One of our primary concerns is supporting SQL Server peer-to-peer replication. The idea is to support several geographically separated nodes. A secondary concern has been using a modern ORM in the middle tier. Our first choice has always been Entity Framework, mainly because th...

Rich Client: Can anyone recommend a replication framework/patterns/tutorials?

Can anyone recommend a replication framework for client-side caching for rich clients - especially the eclipse RCP? Alternatively, tutorials or other reading. I'm currently researching for a project which calls for a rich client to go along side an existing web browser application. The rich client is mainly for more comfortable manipula...

If I have a SQL Server 2005 database that is set up as a Merge Replication Push Subscriber, is it possible to use the same database as Publisher as well?

We have Merge (Push) replication set up between the databases in our different offices. Each database carries the complete set of data, so that the users in each office only need to connect to the database server in their office. When users want to go off-site they need to pull a subset of data to a local (on user's laptop) SQL Express...

Best Hot/Warm Backup Server Replication Strategy (SQL Server 2005)

I have two identical servers with SQL Server 2005 and my application. Hard requirements: I must be able to update data at either server. I must be able to unplug either server without having to reconfigure anything in the database. When a server is plugged back in, it must automatically sync up with the other server. Notes: I pref...

Are table indexes getting replicated to my sqlce database?

Hi i have a ms sql database that is getting replicated to mobile sqlce databases. My question is the following: Are the indexes getting propagated to the sqlce database tables as well? ...

Alternative options to MS SQL REPLICATION

Hi there, I would like to ask if there are any alternative options to ms sql replication(this is what i am using now) for replicating data. Creating a custom architecture for replicating is a good idea? PS. The alternative option must support mobile databases that run on Windows CE/Mobile EDIT: The application should be able to work ...

Primarykey violation in restored database

Hi, I set up the transactional replication(not updatable subscriber) between sql server 2005 database. The tables in published database have identity columns. The tables were replicated without problem. But when I back up and restore the subscriber database, I could not insert row in a table which contains identity increment field and i...

Subscriber database to publisher database

Hi, If the publisher side of a transactional replication database goes down along with its backups for some reason, how would I go about making the subscriber database as a publisher again with minimal impact and time. As I understand at this point in time, the subscriber database comes loaded with triggers and views that are needed fo...

How to set network adapter used by SQL Server Replication?

I have 2 servers running SQL Server 2005 with merge replication set up between them. Each server is connected to the building network, but they also have a cross-over cable connecting them creating a private network. How do I configure merge replication so it uses the private network and not the building network? The private network i...